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:
Step 1
Open SQL Server Management Studio and connect to database engine.
Step 2
In object explorer step down to the Databases node. Expand a database, and then expand Tables.
Step 3
Right-click the Table and click View Dependencies.
Step 4
From Object Dependencies wizard, select Object that depend on, or Objects on which depends. List objects are displayed.
Step 5
Select object from Dependencies grid. Type of object (such as Trigger or SP's) appears in Type box.