Microsoft KB Archive/47249

{|
 * width="100%"|

INF: Sp_foreignkey Does Not Automatically Create a Common Key

 * }

Q47249

-

The information in this article applies to:


 * Microsoft SQL Server for OS/2, version 4.2

-

The documentation on sp_foreignkey in the &quot;Microsoft SQL Server Language Reference&quot; 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

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbZNotKeyword3 kbSQLServ420OS2