PRB: Cannot Create FK Relationship Using Design Table Interface (197799)


The information in this article applies to:

  • Microsoft SQL Server 7.0
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.
Modification Type:MajorLast Reviewed:3/4/2002
Keywords:kbprb KB197799
©2002 Microsoft Corporation. All rights reserved.