Managing primary keys
Table primary keys are managed on the Primary Keys tab of the Table Editor.
To add a primary key to the table:
- Open the table in the Table Editor.
- Open the Constaraints tab then choose the Primary Keys tab.
- Right-click and select the New Primary Key... item from the popup menu.
- Edit primary key properties within the Primary Key Editor dialog.
To edit primary key:
- Open the table in the Table Editor.
- Open the Constaraints tab then choose the Primary Keys tab.
- Right-click the primary key and select the Edit Primary Key item from the popup menu or simply double-click the key to edit.
- Edit primary key properties within the Primary Key Editor Dialog.
To drop the primary key:
- Open the table in the Table Editor.
- Open the Constaraints tab then choose the Primary Keys tab.
- Right-click the key to drop and select the Drop Primary Key item from the popup menu.
- Confirm dropping in the dialog window.
