Experts Exchange connects you with the people and services you need so you can get back to work.
Returns one row for each entity in the current database that references another user-defined entity by name
Returns one row for each user-defined entity referenced by name in the definition of the specified referencing entity.
QUESTION: What objects ARE [referenced by | referencing] X?
-- The following example returns the entities (tables and columns) that are referenced by the database-level DDL trigger ddlDatabaseTriggerLog.
Quesiton: What objects are referenced by X?
What tables, views, functions, etc. does my really long SP reference?
SELECT blah, blah, balh
FROM sys.dm_sql_referenced_entities ('My Object Name', 'OBJECT');
SELECT referenced_schema_name, referenced_entity_name, referenced_minor_name, referenced_minor_id, referenced_class_desc
FROM sys.dm_sql_referenced_entities ('ddlDatabaseTriggerLog', 'DATABASE_DDL_TRIGGER');
-- The following example returns the entities that are referenced by the user-defined function dbo.ufnGetContactInformation.
SELECT referenced_schema_name, referenced_entity_name, referenced_minor_name, referenced_minor_id, referenced_class_desc, is_caller_dependent, is_ambiguous
FROM sys.dm_sql_referenced_entities ('dbo.ufnGetContactInformation', 'OBJECT');
Question: What objects are referencing X?
What functions, stored procs, check constraints, etc. call my table?
SELECT referencing_schema_name, referencing_entity_name, referencing_id, referencing_class_desc, is_caller_dependent
FROM sys.dm_sql_referencing_entities ('Production.Product', 'OBJECT');
Open in new window
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.