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
