Microsoft KB Archive/197799

= PRB: Cannot Create FK Relationship Using Design Table Interface =

Article ID: 197799

Article Last Modified on 3/4/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.