查看所有外键

点击(此处)折叠或打开

1. SELECT 主键列ID=b.rkey
   
2.     ,主键表名称=object_name(b.rkeyid)
   
3.     ,主键列名=(SELECT name FROM syscolumns WHERE colid=b.rkey AND id=b.rkeyid)
   
4.     ,外键表ID=b.fkeyid
   
5.     ,外键表名称=object_name(b.fkeyid)
   
6.     ,外键列ID=b.fkey
   
7.     ,外键列名=(SELECT name FROM syscolumns WHERE colid=b.fkey AND id=b.fkeyid)
   
8.     ,级联更新=ObjectProperty(a.id,'CnstIsUpdateCascade')
   
9.     ,级联删除=ObjectProperty(a.id,'CnstIsDeleteCascade')
   
10. FROM sysobjects a
    
11.     join sysforeignkeys b on a.id=b.constid
    
12.     join sysobjects c on a.parent_obj=c.id
    
13. where a.xtype='f' AND c.xtype='U'
    
14.     

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16131092/viewspace-2144140/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16131092/viewspace-2144140/