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, follow the steps below:
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. |
|
3 |
Select the Operations context menu option The Operations dialog displays. |
|
4 |
Add an operation with a name such as IDX_CustomerID. The IDX_ prefix is optional, but helps to identify the operation. |
|
5 |
In the Stereotype field for the operation, select index (check and unique are also supported). |
|
6 |
Click on the Column tab. |
|
7 |
Select the required columns from the Columns drop-down list in the required order |
|
8 |
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:
