SQLzoo.net

DROP TABLE problems: Foreign key references.

Oracle
You may not drop a table if it is referenced by another table.
Run the tidy code silently
Run set up code


Specific to Oracle
The CASCADE CONSTRAINTS clause can be used to remove the references.
DROP TABLE t_a CASCADE CONSTRAINTS

Related links:

  • CREATE, DROP and ALTER