Home Oracle Commands

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:

  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 



Back to the Top

Simon Sheppard
SS64.com