sql server查询一个表的外键引用情况（非联合外键）

SELECT    fk.name     fkname    ,    ftable.name ftablename,    fcn.name    fkcol     ,    rtable.name ftablename,    rcn.name    rkcolFROM    sysforeignkeysJOIN    sysobjects fk ON sysforeignkeys.constid = fk.idJOIN    sysobjects ftable ON sysforeignkeys.fkeyid = ftable.idJOIN    sysobjects rtable ON sysforeignkeys.rkeyid = rtable.idJOIN    syscolumns fcn ON sysforeignkeys.fkeyid = fcn.id AND sysforeignkeys.fkey = fcn.colidJOIN    syscolumns rcn ON sysforeignkeys.rkeyid = rcn.id AND sysforeignkeys.rkey = rcn.colidWHERE    ftable.id = Object_ID('PFSubAcctEQRef')             --table name

呵呵，其实如果是“非联合外键”的话，查询的结果是：只要有一个外键，就是一条记录：