INF: Sp_foreignkey Does Not Automatically Create a Common Key

ID: Q47249

The information in this article applies to:

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