The syntax of the columnList element is given by
the following simple BNF:
column_list ::= index_column [, index_column]*
index_column ::= column_name [ASC | DESC]
If neither ASC nor DESC is not specified,
ASC, that is, ascending order, is assumed.
Note that it is not necessary to specify an index for a primary key, as the primary key has a unique constraint with an index created automatically.
Table, SecondaryTable, CollectionTable, JoinTable, TableGenerator
| Modifier and Type | Method and Description |
|---|---|
| public String | columnList()
(Required) The columns included in the index, in order,
following the BNF rule |
| public String | |
| public String | |
| public boolean |
| columnList | back to summary |
|---|---|
| public String columnList() (Required) The columns included in the index, in order,
following the BNF rule | |
| name | back to summary |
|---|---|
| public String name() (Optional) The name of the index. Defaults to a provider-generated name. | |
| options | back to summary |
|---|---|
| public String options() (Optional) A SQL fragment appended to the generated DDL which creates this index.
| |
| unique | back to summary |
|---|---|
| public boolean unique() (Optional) Whether the index is unique. | |