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.

 

 

 

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.

 

 

Learn more