Saturday, March 31, 2012

List tables which are dependent on a given table

Option 1: Right-click on a table and choose 'View Dependencies'.

Option 2: For some reason if you want to do it programmatically check out the below code snippet

S.[name] as 'Dependent_Tables'
sys.objects S inner join sys.sysreferences R 
on S.object_id = R.rkeyid
Where S.[type] = 'U' AND R.fkeyid = OBJECT_ID('Person.StateProvince')

No comments:

Post a Comment