Wednesday, November 21, 2007

List tables which are dependent on a given table - SQL Server 2005

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
S.[type] = 'U' AND
R.fkeyid = OBJECT_ID('Person.StateProvince')

here, replace Person.StateProvince with your table name.

No comments: