SQL Query To Find Table Dependencies

 

Use this SQL script to return the table dependencies such as stored procedures for your database objects.

 

You need to change the XType value referenced in the query below to find any of the objects in the following chart:

 

C = Check Vonstraint

D = Default or Default Constraint

F = Foreign Key Constraint

L = Log

Fn = Scalar Function

If = Inlined Table Function

P = Stored Procedure

Pk = Primary Key Constraint

Rf = Replication Filter Stored Procedure

S = System Table

Tf = Table Function

Tr = Trigger

U = User Table

Uq = Unique Constraint

V = View

 

SQL Query:

 

Select Distinct

SysObjects.Name 'Table Name',

Procedures.Name 'Stored Procedure'

 

From SysObjects

Join (SysObjects Procedures

Join SysDepends

on Procedures.Id = SysDepends.Id)

On SysDepends.DepId = SysObjects.Id

 

Where SysObjects.XType = 'U'

 

-- Change XType Values here using chart above

And Procedures.XType = 'P'

 

Group by SysObjects.Name,

SysObjects.Id,

Procedures.Name

 

Order by SysObjects.Name Asc