When you click on the Index card, the Index Definition window is displayed. As with the Foreign Key, you can define a number of indexes for each table. The index can be defined either in tabular form or with the aid of DOMAIN. In the first case, you must enter the columns one after the other, separated by semicolons. In the latter case, a list of columns is displayed just as it is for primary key and foreign key definition.
Click on the Asc and Desc command buttons to define the sorting mode for index columns. The Unique option defines whether the index is to be an identifying index.
To delete an index, delete the definition line from the table display.