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
[quote user="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 [/quote]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
