Modify a primary key constraint (ADP)
Note The information in this topic applies only to a Microsoft Access project (.adp).
Modify a primary key if you want to change the column order, index name, clustered option, or fill factor.
- 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.
- In your database diagram, right-click the table whose primary key you want to modify, and choose Indexes/Keys from the shortcut menu.
- Select the primary key index from the Selected index list.
- Type a new name in the Index name box. Make sure that your new name does not duplicate a name in the Selected index list.
The primary key is updated in the database when you save your database diagram.