Knowledge Base

PRB: Cannot Create FK Relationship Using Design Table Interface

Article ID: 197799

Article Last Modified on 3/4/2002

APPLIES TO

This article was previously published under Q197799

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: kbprb kbpending KB197799


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.