0

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...

Community
  • 1
  • 1
VixterJ
  • 31
  • 5

1 Answers1

0

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.

Mack
  • 2,556
  • 1
  • 26
  • 44