Search code examples
sqlsql-server-2008-r2dmv

Check if SQL object is referenced by any other SQL objects

I was just reading this SO thread and had a question for @Mack regarding whether there is a way to check if a SQL object is referenced by any other SQL objects.

He (@Mack) used T-SQL and DMVs to accomplish something similar in his answer.

Is this possible, if so how?

I would have posted this as a comment, but I don't have sufficient reputation yet...

Solution

  • You can, but not with a DMV instead you'll need a related dynamic management function(DMF) dm_sql_referencing_entities (more info here).

    Here is the code:

    SELECT referencing_schema_name
     , referencing_entity_name
FROM sys.dm_sql_referencing_entities ('*schemaname.objectname*', 'OBJECT');

    Here's a link to the MSDN page on DMVs and DMFs.