why can't i delete this SQL Server table

Question

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?

score 1 · Accepted Answer · edited May 23 '17 at 11:55

1

Maybe this answer can help you:

edited May 23 '17 at 11:55

Community

answered Dec 31 '10 at 02:05

duffymo

1 Answers1