Dependencies on a specific table column

By lhughes92, 2013/06/18

SQL Server provides a built-in stored procedure, sp_depends, that returns object dependencies. Recently, I discovered a need for determining dependencies on a table column, not just the table itself. For example, a table may be referenced by many stored procedures and views, but a specific column in that table may only be referenced in a few of those objects. The following code will determine which views and stored procedures reference a specific column in a table, and whether the object is a view (V) or stored procedure (P).

Total article views: 412 | Views in the last 30 days: 8

FORUM

dependencies between stored procedures

Is there a way to identify the dependencies between stored procedures

SCRIPT

Get dependant Objects

Get Dependant Objects by passing table name or stored procedure name.

SCRIPT

Parse the dependency chain of an object

Parses up & down the dependency chain of an object.

SCRIPT

Dependencies View 2008

Provides a list of dependencies for a stored procedure

FORUM

How to find the objects that use a stored procedure

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Dependencies on a specific table column

dependencies between stored procedures

Get dependant Objects

Parse the dependency chain of an object

Dependencies View 2008

How to find the objects that use a stored procedure

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: