Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

How to: View the Dependencies of a Table (SQL Server Management Studio)

Some database objects rely upon the presence of other database objects. For instance, a view or stored procedure relies upon an underlying table to provide the data. Use Object Explorer to identify dependencies before changing or deleting an object.

  1. In Object Explorer, expand Databases, expand a database, and then expand Tables.

  2. Right-click a table, and then click View Dependencies.

  3. In the Object Dependencies <object name> dialog box, select either Objects that depend on <object name>, or Objects on which <object name> depends. The Dependencies grid displays the list objects.

  4. Select an object in the Dependencies grid. The type of object (such as "Trigger" or "Stored Procedure"), appears in the Type box.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft