Create a Primary Key

How to

To define a simple Primary Key consisting of a single column

Step	Action	See also
1	Right-click on the table in a diagram and select the Attributes context menu option. The Attributes dialog displays.
2	Select the column that makes up the Primary Key.
3	Select the Primary Key checkbox and click on the Save button. A stereotyped operation is automatically created; it is this operation that defines the Primary Key for the table. To remove a Primary Key, simply delete this operation.

Step

Action

See also

Right-click on the table in a diagram and select the Attributes context menu option.

The Attributes dialog displays.

Select the column that makes up the Primary Key.

Select the Primary Key checkbox and click on the Save button.

A stereotyped operation is automatically created; it is this operation that defines the Primary Key for the table.

To remove a Primary Key, simply delete this operation.

To define a complex Primary Key, consisting of more than one column

Step	Action	See also
1	Follow the steps above to create a Simple Primary Key; it doesn't matter which column you choose.
2	Right-click on the table in a diagram and select the Operations context menu option. The Operations dialog displays.
3	Select the Primary Key operation (its name begins with PK_) and then click on the Column tab.
4	Click on the New button to add a column to the Primary Key, select a column from the Column Name list box, and then click on the Save button.
5	Click on the Hand buttons (up and down arrow) to change the order of columns in the Primary Key, if necessary.