Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
A primary key or unique constraint must be defined for table <Tablename> before it can participate in a relationship. (Visual Database Tools)
Collapse the table of content
Expand the table of content

A primary key or unique constraint must be defined for table <Tablename> before it can participate in a relationship. (Visual Database Tools)

In order to create a foreign key relationship, at least one of the two tables must have a primary key or unique constraint defined. To create the relationship you are attempting to create, first create a primary key for one of the tables.

Community Additions

ADD
Show:
© 2015 Microsoft