Create a Primary Key

How To:

To define a simple Primary Key consisting of a single column, follow the steps below:

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, follow the steps below:

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

Learn more