Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Create an Index
How to
To create an Index
Step |
Action |
See also |
|---|---|---|
1 |
Ensure that the column(s) to be used in the index have already been defined in the table.
|
|
2 |
Right-click on the required table either in a diagram or in the Project Browser, and select the Operations context menu option. The Operations dialog displays.
|
|
3 |
Add an operation with a name such as IDX_CustomerID. The IDX_ prefix is optional, but helps to identify the operation.
|
|
4 |
In the Stereotype field for the operation, select index (check and unique are also supported).
|
|
5 |
Click on the Column tab.
|
|
6 |
Select the required columns from the Columns drop-down list in the required order.
|
|
7 |
Click the Save button to save changes.
|
|
Example
In the example below, the Order element shows how an index looks in a diagram:
Notes
| • | The unique characteristic applied to a single column ensures that no two data values in the column can be identical; the unique stereotype applied to an index ensures that no two combinations of values across a set of columns can be identical |
Learn more
