开发者

why can't i delete this SQL Server table [duplicate]

This question already has answers here: 开发者_开发百科 Closed 12 years ago.

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?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜