DESTROYING/DELETING/DROPING TABLES

Sometimes tables within a particular database become obsolete (outdated) and need to be discarded. In such situation using the DROP TABLE statement with the table name can destroy a specific table.

Syntax:

DROP TABLE ;

Example:

Remove the table EMP_MSTR along with the data held.

DROP TABLE EMP_MSTR;

Output:

Table dropped.