クエリー・データベースのプライマリ・キーと外部キー

SELECT      =object_name(b.rkeyid)  

    ,   ID=b.rkey 

    ,    =(SELECT name FROM syscolumns WHERE colid=b.rkey AND id=b.rkeyid) 

    ,     =object_name(b.fkeyid) 

    ,   ID=b.fkey 

    ,    =(SELECT name FROM syscolumns WHERE colid=b.fkey AND id=b.fkeyid) 

    ,    =ObjectProperty(a.id,'CnstIsUpdateCascade') 

    ,    =ObjectProperty(a.id,'CnstIsDeleteCascade') 

FROM sysobjects a 

    join sysforeignkeys b on a.id=b.constid 

    join sysobjects c on a.parent_obj=c.id 

WHERE a.xtype='F' AND c.xtype='U' 

    --and object_name(b.rkeyid) like '%%' --