Oracle

Dropping a Table

Figo Kim 2006. 11. 24. 07:26
  • All data and structure in the table are deleted.
  • Any pending transactions are committed.
  • All indexes and constraints are dropped.
  • Roll back is impossible.

DROP TABLE tablename;


** The Oracle server doesn't question the action when you issue the DROP TABLE statement.

** Auto commit.