sp_fkeys (version 6.5)

Returns logical foreign key information for the current environment. This procedure shows foreign key relationships including disabled foreign keys. Application coding that includes tables with disabled foreign keys could be implemented as follows:

• Temporarily disable constraint checking (ALTER TABLE NOCHECK or CREATE TABLE NOT FOR REPLICATION) while working with the tables, and enable again later.
• Use triggers or application code to enforce relationships.

For additional syntax information for sp_fkeys, see the Microsoft SQL Server Transact-SQL Reference.

For more information on disabling constraints, see Disabling Constraints.