PRB: Cannot Create FK Relationship Using Design Table Interface

• Microsoft SQL Server version 7.0

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:

• Use the Database Diagrams option with Enterprise Manager to define relationships between tables.
  
  -or-



• Create and/or modify the tables by using the CREATE TABLE or ALTER TABLE statements in SQL Server Query Analyzer, specifying or adding foreign key constraints.

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