Friday, November 17, 2006

Drop Database Table Command -- Oracle

When a table is no longer needed in the database, you may want to drop it. But if it has referential integrity, a simple "drop table tablename" won't suffice.

You will need to do the following:

SQL>drop table tablename cascade constraints (which removes the referential constraints)

No comments: