Dropping tables
When you drop a table, you delete the data and the table definition. You also delete all synonyms, views, indexes, referential constraints, and check constraints that are associated with that table.
About this task
The following SQL statement drops the YEMP table:
DROP TABLE YEMP;Use the DROP TABLE statement with care: Dropping
a table is not equivalent to deleting all its rows. When you
drop a table, you lose more than its data and its definition. You
lose all synonyms, views, indexes, and referential and check constraints
that are associated with that table. You also lose all authorities
that are granted on the table.
Related reference: