Sunday, May 19, 2013

How to get ms sqlserver relation name, relationship table name

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

No comments:

Post a Comment