INF: Sp_foreignkey Does Not Automatically Create a Common Key

ID: Q47249

The information in this article applies to:
  • Microsoft SQL Server for OS/2, version 4.2
The documentation on sp_foreignkey in the "Microsoft SQL Server Language Reference" incorrectly states the following:
When you define a foreign key, a common key is automatically defined between the pktabname and tabname tables or views, and added to syskeys.

Defining a foreign key with sp_foreignkey does not automatically create a common key.

Additional query words: stored procedures

Keywords : kbother SSrvDoc_Err SSrvServer
Version : 4.2
Platform : OS/2
Issue type :


Last Reviewed: March 9, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.