Export (0) Print
Expand All
Expand Minimize
1 out of 6 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.