Export (0) Print
Expand All
Expand Minimize
1 out of 12 rated this helpful - Rate this topic

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).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.