Hi,

When I try to delete some records from the primary table it says that it has related records in other tables, my questin is : 

- Is there a way to tell which foreign table has records related to the primary table?

Thanks

Tarek Al-Jamal

tarekj:

Hi,

When I try to delete some records from the primary table it says that it has related records in other tables, my questin is : 

- Is there a way to tell which foreign table has records related to the primary table?

Thanks

Tarek Al-Jamal

1 EXEC sp_help 'primary table'
2 EXEC sp_fkeys 'primary table'

By this way I have to check these tables one by one to check if they have records or not, I want to know which one has the related records so I can go directly and delete them.

Thanks

Hi,

You can check running sp_depends 'tblename' to check the dependancy!!