ERROR: Foreign key constraint on ... prevents drop of table

Reason:

You attempted to drop a table using drop_table() but there is a foreign key constraint on another table that is dependent on it.

Resolution:

Drop any dependent foreign key constraints first, then drop the table; or use the cascade option in drop_table().

Tips:

  • Use the star$constraints view to find foreign key constraints dependent on the table to be dropped.
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk