It is possible to define table index. Those index can be used for:

  • Define primary key.
  • Define Constraint.
  • Improve search performance


Index property are:

Name
Index Name

Label
Label (language based) to show when user reference this index.

Columns
Column define the index.Syntax:

<Column1>; ... ;<ColumnN>

where <ColumnX> is a column of table. It is possible to use just collumn with DataType set to NUMERIC, DOUBLE, CHAR, DATETIME o BOOLEAN.

Unique
If index is unique. When set to true it do not admit duplicate values for column.

Last updatedFriday, 19 November 2010 23:14