SQLzoo.net

DROP TABLE problems: Foreign key references.

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


Specific to SQL Server
We can find out what the foreign keys are using sp_help table_name

Related links:

  • CREATE, DROP and ALTER