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:
Post a Comment