There are two types of dependencies: 'UP' and 'DOWN'
Dependencies 'UP' include all objects, which refer in any way to the object in question. For example, if you want to see 'UP' dependencies for a table, it will be other tables, which have foreign keys to this table; stored procedures and views, which use this table in their SQL syntax, etc. We use term 'Referred By' for this type of dependencies.
Dependencies 'DOWN' include all objects, which the object in question calls or uses directly or indirectly. For example, if you want to see 'DOWN' dependencies for a stored procedures, it will be all nested stored procedure; tables, which this stored procedure uses in its syntax; triggers, which these tables can invoke, etc. We use term 'Referring To' for this type of dependencies.
Dependencies View is integrated into Entity Relationship diagram panel so that you could have a comprehensive picture of object dependencies using both graphical and hierarchical presentations. Dependences View is located at the right side of E/R Diagram panel. It has two tabs: Dependencies and Object List.
To open object dependencies view, select required object, such as a table or stored procedure, in the Object Explorer tree and choose Dependencies from the popup menu.
Dependencies tab
Dependencies tab shows a hierarchical tree of object's dependencies. Each object node, such as table or stored procedure, has two subfolders: Referring To and Referred By.
Referring To subfolder shows all object's "DOWN" dependencies.
Referred
To subfolder shows all object's "UP" dependencies.
The subfolder label is followed by a number, which is a total number of dependent objects of this type (UP or DOWN).
When you select any object in the Dependencies tree, it is automatically highlighted in E/R diagram so that you could see this object dependencies using a graphical representation along with detail object structure and SQL syntax.
Object List tab
Object List tab shows list of all unique objects displayed in E/R diagram that are part of objects dependencies hierarchy (both "UP" and "Down" dependencies).
When you select any object in the list, it is automatically highlighted in E/R diagram so that you could see this object dependencies using a graphical representation along with detail object structure and SQL syntax.