2007/9/28更新

対応バージョン: 11.9.2

sp_helpconstraintを使用する。

例) 外部キーとプライマリキーが定義されているtestというテーブルの場合

1> sp_helpconstraint test
 name      definition
 --------- ---------------------------------------------------------------
 test_fk1  test_info FOREIGN KEY (userid) REFERENCES test_org_info(userid)
 test_pk   PRIMARY KEY INDEX (userid) : CLUSTERED, FOREIGN REFERENCE

Total Number of Referential Constraints: 1

Details:
-- Number of references made by this table: 0
-- Number of references to this table: 1
-- Number of self references to this table: 0

Formula for Calculation:
Total Number of Referential Constraints
= Number of references made by this table
+ Number of references made to this table
- Number of self references within this table