View Table Dependencies Of Table In SQL Server
This article explains how to view table dependencies of table.
To view the dependencies of table follow these steps:
Open SQL Server Management Studio and connect to database engine.
In object explorer step down to the Databases node. Expand a database, and then expand Tables.
Right-click the Table and click View Dependencies.
From Object Dependencies wizard, select Object that depend on, or Objects on which depends. List objects are displayed.
Select object from Dependencies grid. Type of object (such as Trigger or SP's) appears in Type box.