|
visakh16
Very Important crosS Applying yaK Herder
India
48012 Posts |
 Posted - 05/10/2008 : 03:52:06
|
This lists all the tables which references the unsused tables.
SELECT OBJECT_NAME(f.constid) AS 'ForeignKey', OBJECT_NAME(f.fkeyid) AS
'FKTable', c1.[name] AS 'FKColumnName', OBJECT_NAME(f.rkeyid) AS 'PKTable',
c2.[name] AS 'PKColumnName'
FROM sysforeignkeys f
INNER JOIN syscolumns c1
ON f.fkeyid = c1.[id]
AND f.fkey = c1.colid
INNER JOIN syscolumns c2
ON f.rkeyid = c2.[id]
AND f.rkey = c2.colid
WHERE OBJECT_NAME(f.rkeyid) IN (YourunusedTableList) |
 |
|
Drop script
