why can't i delete this SQL Server table [duplicate]
Possible Duplicate:
How to find foreign key dependencies in SQL Server?
i am trying to delete a table in SQL server mgmt studio by rightclicking and clicking "DELETE". I am getting this error:
Could not drop object 'dbo.Team' because it is referenced by a FOREIGN KEY constraint. (.Net SqlClient Data Provider)
how can i find out what is referencing this table as nothing should be. Why wouldn't SQL server mgmt studio help point you to what is referencing it?
Maybe this answer can help you:
How to find foreign key dependencies in SQL Server?
精彩评论