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.
DROP TABLE users;
DROP PROFILE developer;
DROP VIEW sales_dept;
Related Code Snippets:
- Drop User example - Drop the account that owns the database objects required to run