Indexes
Indexes ( 
) can be found in the Database tool window. For the reference on other node and object icons, refer to the Data sources and their elements chapter of Database window topic. For the table column icons, refer to the Possible icon combinations for columns chapter.
In the Database tool window ( ) , expand the data source tree until the nodes of columns.
Right-click the table or column node and select .
In the dialog that opens, enter the name of your index in the Name field.
In the Columns pane, click the Add button (
).In the Column Name field, specify the name of the column that you want to add to the index.
In the Preview pane, you can view and change the generated SQL code.
Click OK to add your index.
To view and modify these templates, open the settings CtrlAlt0S and navigate to . Click the Code Generation tab.
The templates can contain variables and text. When you generate a name, the specified text is reproduced literally. For example, when you apply the
{table}_pktemplate in theactortable, the generated name of the primary key will beactor_pk.To see information about variables and their usage, click a field and press Ctrl0K,0I.
{unique?u:}checks if the index is unique and inserts the corresponding sequence of characters. If the index is unique, the template generates a name with the sequence of characters specified between?and:. For the{unique?u:}template, it isu. If the index is not unique, the sequence between:and}is inserted. For the{unique?u:}template, it is nothing.Example
You have the
personstable with columnsFirstNameandLastName. The{table}_{columns}_{unique?u:}indextemplate generates the following name for the not unique index:persons_FirstName_LastName_index.