DROP TABLE

Drop a table.

Syntax:

   DROP TABLE [schema.]table [CASCADE CONSTRAINTS];

"I've had a wonderful time, but this wasn't it." - Groucho Marx

Related Commands:

  ALTER TABLE DROP column
  ALTER TABLE DROP primary key/constraint
  DROP INDEX
  DROP SNAPSHOT
  DROP VIEW

Related Views:

  DBA_ALL_TABLES         ALL_ALL_TABLES         USER_ALL_TABLES
  DBA_TABLES             ALL_TABLES             USER_TABLES             TAB
  DBA_PARTIAL_DROP_TABS  ALL_PARTIAL_DROP_TABS  USER_PARTIAL_DROP_TABS