Managing primary keys
Table primary keys are managed on the Primary Keys tab of the Table Editor.
Add Primary Key
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. |
Edit Primary Key
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. |
Drop Primary Key
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. |
