Give all dependecy related table from the database. Its not included reference key.

SELECT DISTINCT OBJECT_NAME(DEPID) DEPENDENT_ON_OBJECT, OBJECT_NAME (ID) USED_IN_OBJECT FROM SYS.SYSDEPENDS
order by OBJECT_NAME(DEPID),OBJECT_NAME (ID)

Leave a comment