The columns in table '<0s>' do not match an existing enabled primary key or UNIQUE constraint.

Message Text

The columns in table '<0s>' do not match an existing enabled primary key or UNIQUE constraint.

Explanation

At least one table participating in a relationship must have either a PRIMARY KEY or a UNIQUE constraint.

Action

After setting up a PRIMARY KEY or a UNIQUE constraint for one of the tables you’ve selected, you can then define other relationships for that table.

See Also
ALTER TABLE How to create a UNIQUE constraint on an existing table (Enterprise Manager)
CREATE TABLE How to create a UNIQUE constraint when creating a table (Enterprise Manager)
Creating and Modifying UNIQUE Constraints Key Object
Creating SQL Server Tables Primary Key Constraints

 

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.