Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle DROP Command      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: DROP

Definition:
The Oracle DROP command is used to remove database objects (tables, functions, views, profiles, etc) from the database. It does this by deleting the object definition and any associated references.

When a table is dropped, all the tables' rows, indexes and privileges will also be removed. No DML triggers will be fired.

As of Oracle 10g, when a table is dropped it is moved into the recycle bin unless the PURGE modifier is used. If the PURGE modifier is used then the table is dropped completely from the database and is unrecoverable.

The DROP command may also be used to remove a database link. See the CREATE DATABASE LINK page for more information.

Example Syntax:

DROP TABLE users;

DROP PROFILE developer;

DROP VIEW sales_dept;



Related Links:

Related Code Snippets:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 62 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?