The index editor is a wizard like modal editor that aims to simplify the process of creating and updating a table index.


The index editor can be open either when a new table index is created by using the diagram palette - only if this option is set in preferences - or to edit an existing table index simply by doing a double-click on an index row of a table element in the diagram. The wizard can be closed at any time by pressing the Finish button once the minimum information has been provided, when a new table index is created from the diagram palette there is an additional button - Add new.. that can be used to add the new table index and immediately restart the wizard to create a new one.


First wizard page shows basic properties of a table index element, the only required information is the index name which can't be left empty and it also must be unique within a database table.


When the primary flag is set for an index if another primary index were already defined the primary flag will be set to false on that index and current index will become the primary key of the table.



Second and last wizard page can be used to edit the fields that are part of the index and their sort order. It is mandatory to have at least one field part of the index and a field can only be included once.