Find the dependent sql objects on a defined object:
Below query shows the dependent sql objects like tables, views etc. of defined object (here. YourObject).
SELECT referencing_schema_name, referencing_entity_name,referencing_id, referencing_class_desc, is_caller_dependentFROM sys.dm_sql_referencing_entities ('YourObject', 'OBJECT');GO
Below query shows the dependent sql objects like tables, views etc. of defined object (here. YourObject).
SELECT referencing_schema_name, referencing_entity_name,referencing_id, referencing_class_desc, is_caller_dependentFROM sys.dm_sql_referencing_entities ('YourObject', 'OBJECT');GO
No comments:
Post a Comment
Enter your comments here...