BUG: SQL Object Manager Not Allow Foreign Key on Same Table |
Q121238
The Microsoft SQL Object Manager does not allow a foreign key to be
defined on the same table as the primary key.
The Keys dialog of Object Manager does not list the server chosen
in the pick box to match a foreign key, so you cannot create a
foreign key against the same table as the primary key.
Use the sp_foreignkey stored procedure to accomplish this objective.
Microsoft has confirmed this to be a problem in SQL Object Manager for Windows NT and SQL Object Manager for Windows. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
Keywords : kbtool
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2
|
Last Reviewed: March 21, 1999 © 2001 Microsoft Corporation. All rights reserved. Terms of Use. |