查询sql server中所有的外键信息

从左到右分别是: 外键约束名,子表名,外键列名,父表名

select fk.name fkname , ftable.name ftablename, cn.name fkcol, rtable.name ftablename from sysforeignkeys

  join sysobjects fk

    on sysforeignkeys.constid = fk.id

  join sysobjects ftable

    on sysforeignkeys.fkeyid = ftable.id

  join sysobjects rtable

    on sysforeignkeys.rkeyid = rtable.id

  join syscolumns cn

    on sysforeignkeys.fkeyid = cn.id and sysforeignkeys.fkey = cn.colid

Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.