SELECT
name, OBJECT_NAME(parent_object_id) 'ReferenceTO', OBJECT_NAME(referenced_object_id) 'ReferenceBy'
FROM
sys.foreign_keys
where OBJECT_NAME(referenced_object_id) like '%ABC%'
order by name
name, OBJECT_NAME(parent_object_id) 'ReferenceTO', OBJECT_NAME(referenced_object_id) 'ReferenceBy'
FROM
sys.foreign_keys
where OBJECT_NAME(referenced_object_id) like '%ABC%'
order by name
No comments:
Post a Comment