How to create or delete a PRIMARY KEY constraint using a database diagram (Enterprise Manager)

To create or delete a PRIMARY KEY constraint using a database diagram

1. Open a database diagram.
2. Click the primary key columns for the table whose PRIMARY KEY constraint you want to create or 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 clear Set Primary Key.

Caution Deleting a PRIMARY KEY constraint results 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.

See Also