INF: Sp_fkeys Does Not List Keys Identified by Sp_foreignkey

ID: Q169051

The information in this article applies to:

Microsoft SQL Server, versions 6.0 and 6.5

SUMMARY

The sp_fkey stored procedure only returns information about columns explicitly defined by ALTER TABLE or CREATE TABLE with a FOREIGN KEY constraint, and not for columns identified by sp_foreignkey. The sp_foreignkey stored procedure was last supported in SQL Server 4.21a, and is only provided for backwards compatibility with later systems. The use of sp_foreignkey was made unnecessary with the implementation of declarative referential integrity (DRI) in SQL Server 6.0.

MORE INFORMATION

For more detailed information, see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q133177
   TITLE     : INF: Changes to SQL Server 6.0 That May Affect 4.2x Apps

Also see the ALTER TABLE command in the Transact-SQL Reference 6.0 and the ALTER TABLE command in What's New in SQL Server 6.5.

Additional query words: sp_fkeys

Keywords          : kbusage SSrvGen 
Version           : 6.0 6.5
Platform          : WINDOWS
Issue type        : kbinfo

Last Reviewed: May 29, 1997