DROP

DROP:

• This command is used to drop entire data from database.
• It removes the definition of the oracle table.
• The command not only drops the table and along with the associated INDEXES also.

Guidelines to Drop Table:

• The data is totally deleted from the table.
• Any VIEWS and SYNONYAMS will remain but are dept in invalid state.
• Any pending transactions are committed.
• Only the create or owner of the table or a USER with DROP any table privilege can remove a table from Database.
• The DROP Table statement once executed is irreversible.

Syntax:

drop table <table name> [CASCADE CONSTRAINTS];

Ex:

SQL> drop table emp;

SQL> drop table employee purge;

SQL> drop table temp CASCADE CONSTRAINTS;