SQL Dependencies

The topics in this section describe SQL dependencies on user-defined entities and how to report these dependencies. SQL dependencies are the by-name references that are used in SQL expressions that make one entity dependent on another entity. For example, views and stored procedures depend upon the existence of tables that contain the data returned by the view or procedure.

In This Section

• Understanding SQL Dependencies
  Explains SQL dependencies and how the Database Engine obtains and maintains dependency information.

• Reporting SQL Dependencies
  Explains how to report on SQL dependencies by using the system catalog view and dynamic management functions.

Reference

sys.sql_expression_dependencies (Transact-SQL)

sys.dm_sql_referenced_entities (Transact-SQL)

sys.dm_sql_referencing_entities (Transact-SQL)

See Also

Tasks

How to: View SQL Dependencies (SQL Server Management Studio)