INF: Sp_fkeys Does Not List Keys Identified by Sp_foreignkeyLast reviewed: May 28, 1997Article ID: Q169051 |
The information in this article applies to:
SUMMARYThe 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 INFORMATIONFor 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 AppsAlso 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
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |