addIndex

The addIndex element allows a new index to be added to the schema.

Example:

<addIndex name="my_new_index" columns="alt_address, case_wip2wipbin" table="case">
   <description>This is the description of my custom index</description>
</addIndex>

Required Attributes:

Attribute Name

Description

name

Specifies the name of the index.

columns

A comma separated list of columns that make up the index. This can include fields and relations.

table

Specifies the name of the table on which this index should be added.


Optional Child Elements:

Element Name

Default

Description

description

 

Description of the index and its purpose.

isUnique

 

Specifies if the index is a unique index or not.

See Also

schemaScript

addColumn

addExclusiveRelationSet

addJoin

addRelation

addSqlView

addSqlViewColumn

addTable

addView

addViewColumn

updateColumn

updateIndex

updateJoin

updateRelation

updateTable

updateSchema

updateSqlView

updateSqlViewColumn

updateView

updateViewColumn

Next

addJoin

addIndex