Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Dependencies on a specific table column

By lhughes92,

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: 505 | Views in the last 30 days: 7
 
Related Articles
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.

FORUM

How to find the objects that use a stored procedure

How to find the objects that use a stored procedure

SCRIPT

Dependencies View 2008

Provides a list of dependencies for a stored procedure

 
Contribute

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

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones