BUG: SQL Object Manager Not Allow Foreign Key on Same Table

ID: Q121238

The information in this article applies to:

Microsoft SQL Server version 4.2x

BUG# 10177 (4.21)

SYMPTOMS

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.

WORKAROUND

Use the sp_foreignkey stored procedure to accomplish this objective.

STATUS

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 SSrvObj_Man kbbug4.21 SSrvWinNT 
Version           : 4.21
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 20, 1999