Switch to: V10V9V8V7V6V5

Table Dialog - Uniques Tab Help

Using this tab-panel you can create a new UNIQUE constraint for this table or modify an existed one.

Table Dialog - Uniques Tab

There are two major areas in the Uniques tab-panel:

  • List of Uniques.
  • List of Fields of the selected UNIQUE constraint.

List of Uniques

This panel contains the list of Table UNIQUE constraints.

There are three ways to add a new UNIQUE constraint:

  • Push button Plus on the bottom panel.
  • Left Click on the last row, in column Name, then enter the name for new UNIQUE.
  • Right Click on a row with existing UNIQUE, then choose Duplicate item.

List of Uniques

In this panel you can define set of fields for selected UNIQUE and their order.

  • To add field - click on the empty row, then select a field from the pop-up menu.
  • To change fields order - click on a row with the field name, then click on arrow (UP/DOWN) in the bottom panel to change order.