Table / Index PDF Print E-mail

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 Updated on Thursday, 01 October 2009 14:46