Annotation Interface Index


@Target({}) @Retention(RUNTIME) public @interface Index
Used in schema generation to specify creation of an index.

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.

Since:
2.1
See Also:
  • Required Element Summary

    Required Elements
    Modifier and Type
    Required Element
    Description
    (Required) The columns included in the index, in order, following the BNF rule column_list given above.
  • Optional Element Summary

    Optional Elements
    Modifier and Type
    Optional Element
    Description
    (Optional) The name of the index.
    (Optional) A SQL fragment appended to the generated DDL which creates this index.
    boolean
    (Optional) Whether the index is unique.
  • Element Details

    • name

      String name
      (Optional) The name of the index.

      Defaults to a provider-generated name.

      Default:
      ""
    • columnList

      String columnList
      (Required) The columns included in the index, in order, following the BNF rule column_list given above.
    • unique

      boolean unique
      (Optional) Whether the index is unique.
      Default:
      false
    • options

      String options
      (Optional) A SQL fragment appended to the generated DDL which creates this index.
      Since:
      3.2
      Default:
      ""