List of MSSQL foreign key constrants
by Taavi Rammar

In order to get list of all foreign constraints with all nessecery information for scripting, run following in your query analyzer:
select CCU.table_name src_table, CCU.constraint_name src_constraint, CCU.column_name src_col, KCU.table_name target_table, KCU.column_name target_col
from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CCU, INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC, INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU
where CCU.constraint_name = RC.constraint_name and KCU.constraint_name = RC.unique_constraint_name
order by CCU.table_name, CCU.constraint_name

Copyright by techTips