To view or edit an index'sproperties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.
The General tab contains the following properties:
|
Property |
Description |
|---|---|
Name/Code/Comment |
Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field. |
Stereotype |
Extends the semantics of the object. You can enter a stereotype directly in this field, or add stereotypes to the list by specifying them in an extension file. |
|
Owner |
[if supported by the DBMS] Specifies the user who is the owner of the object. This is usually its creator. Use the tools to the right of the list to create, browse for, or view the properties of the currently selected user. |
|
Table |
Specifies the table to which the index belongs. |
|
Type |
Specifies the type of index (if supported by your DBMS). For information about SAP® Sybase® IQ index types, see Indexes (IQ). |
|
Unique |
Specifies that the index cannot contain duplicate values. |
|
Cluster |
Specifies that the index is a clustered index. A
table cannot have more than one clustered index.
Note: Clusters in
Oracle 11 and higher are modeled as extended objects with a
<<Cluster>> stereotype (see Clusters (Oracle)).
|
Keywords |
Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas. |
The following tabs are also available:
- Columns - Lists the columns with which the index
is associated (see Creating Standard, Key, or Function-Based Indexes). Use
the following tools to specify columns:
Tool Description N/A Columns definition - Select the appropriate key to empty the list and replace it with the columns associated with the key. Add Columns - Choose columns from the table to add to the list. Add / Insert a Row [if your DBMS supports function-based indexes] - Create a new row, then click in the Expression column and click the ellipsis button to open the SQL Editor to specify an expression. For example, to define an index to convert all names to lowercase to simplify searching, you could enter an expression such as: lower(SURNAME)
