The columns in table <Tablename> do not match an existing primary key or UNIQUE constraint. (Visual Database Tools)
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

The columns in table <Tablename> do not match an existing primary key or UNIQUE constraint. (Visual Database Tools)

The columns on the primary key side of a foreign key relationship must participate in either a Primary Key or a Unique Constraint. 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.

For more information, see How to: Create Unique Constraints (Visual Database Tools) and How to: Create Primary Keys (Visual Database Tools).

Show:
© 2016 Microsoft