INF: Sp_fkeys Does Not List Keys Identified by Sp_foreignkey (169051)
The information in this article applies to:
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
This article was previously published under Q169051 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 ALTER TABLE command in the Transact-SQL Reference 6.0 and the
ALTER TABLE command in What's New in SQL Server 6.5.
| Modification Type: | Major | Last Reviewed: | 9/1/2006 |
|---|
| Keywords: | kbinfo kbusage KB169051 |
|---|
|