Microsoft KB Archive/169051

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 15:34, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base

INF: Sp_fkeys Does Not List Keys Identified by Sp_foreignkey

Article ID: 169051

Article Last Modified on 9/1/2006


  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q169051


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.


For more detailed information, 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: kbinfo kbusage KB169051