Just Learned - Check dependencies of Table

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

Check dependencies of Table

Jul 4 2012 12:00AM by Sudeep Raj

I needed to check where all a table is being used in a database or which objects are dependent on a table. Searched google and Pinal was on top :) Here is the code.

SELECT referencing_schema_name, referencing_entity_name,
 referencing_id, referencing_class_desc, is_caller_dependent
 FROM sys.dm_sql_referencing_entities ('YourObject', 'OBJECT');
 GO

Short and sweet!!

Read More.. [33 clicks]

Published under: SQL Server Tips · · · ·

Previous: Visual Studio 2012 New Features: Code Clone Analysis
Next: Easy tool to compare schema and data of 2 Tables

Sudeep Raj

12 · 13% · 4287

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it


	Submit

1 Comments

This is certainly short and sweet. Please note that this is available only from SQL Server 2008 onwards.

Many years ago, I wrote a function that uses a recursive CTE and retrieves the dependency chain along with a hierarchical view of the dependency chain. You can find it here.

commented on Jul 5 2012 1:01AM

Jacob Sebastian

1 · 100% · 32002

Your Comment

Sign Up or Login to post a comment.

"Check dependencies of Table" rated 5 out of 5 by 9 readers +Sudeep Raj