PRB: Cannot Create FK Relationship Using Design Table Interface

ID: Q197799


The information in this article applies to:


SYMPTOMS

While you are using the Enterprise Manager to create or edit table properties, the Relationships tab in the Properties window does not provide you with any option to add new foreign key relationships. It only gives the option to modify existing relationship properties.


WORKAROUND

To work around this problem you can do either of the following:


MORE INFORMATION

For more information on working with database diagrams, refer to the topic "Creating and Managing Database Diagrams" topic in the SQL Server 7.0 Books Online.

Additional query words: MMC SEM EM GUI transact-sql tran-sql trans-sql tsql
t-sql


Keywords          : SSrvDRI SSrvEntMan SSrvTran_SQL 
Version           : WINNT:7.0
Platform          : winnt 
Issue type        : kbprb 

Last Reviewed: April 20, 1999