Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which SQL Server provides.
By using this stored procedure we can easily determine all the dependencies of particular table.
The stored procedure is sp_msdependencies
We can use this stored procedure as shown below
Execute sp_msdependencies ‘tableName’
For example I am using Adventureworks2012 and I want to know the dependencies of product table then I have to write following command
EXEC sp_msdependencies '[Production].[Product]'
When I run this command I get result as shown in below figure
I hope this tip may help you somewhere.
Thanks for reading.