Delete a Primary Key Constraint

Delete a primary key constraint when you want to remove the requirement for uniqueness for the values entered in a column or a combination or columns.

Delete a primary key constraint by creating a new primary key

1. In the Database window, click Database Diagrams   under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, select the primary key columns for the table whose primary key constraint you want to delete. A primary key column is identified by a primary key symbol in its row selector.
3. Right-click the row selector for the column and select Set Primary Key.

Delete a primary key constraint

1. In the Database window, click Database Diagrams   under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, select the table whose primary key constraint you want to delete.
3. Right-click the table and select Indexes/Keys.
4. Select the primary key index from the Selected index list.
5. Choose Delete.

   Caution   Choosing Delete will result in an action that cannot be undone without losing all other changes made to the database diagram. To undo this action, close this database diagram and all other open database diagrams without saving the changes.

The constraint is deleted from the database when you save the database diagram.