SQL Clone
SQLServerCentral is supported by Redgate
 
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)

Find function dependencies

By Andy Robertson,

This script creates a table of functions.

Then uses the sys.dm_sql_referencing_entities table function to find all the dependent objects for each function.

The result is a table of functions with empty columns if the are no dependent objects or details of each dependent object.

Total article views: 366 | Views in the last 30 days: 29
 
Related Articles
ARTICLE

Data Profiling Column Functional Dependency T-SQL

This article demonstrates Data Profiling Functional Dependency

FORUM

Sequence of Database Objects Dependency - SQL 2005

Sequence of Database Objects Dependency - SQL 2005

FORUM

Find dependencies of an object across the database

Find dependencies of an object across the database

BLOG

Objects dependency check up

It’s a very good practice that you check the dependencies of the other objects when you change an ob...

SCRIPT

Parse the dependency chain of an object

Parses up & down the dependency chain of an object.

 
Contribute