Quick Search:
 
 The Oracle DROP Command      [Return To Index] Jump to:  

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 |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org