Online Documentation for SQL Manager for InterBase/Firebird

Unique constraints


The Uniques tab is provided for managing table UNIQUE constraints. Double-click a key to open Constraints Editor for editing the unique constraint.

 

Right-click a key to display the context menu allowing you to create new, edit, rename, or drop the selected unique key. Using the menu you can also recompute the underlying index and export the list of the table unique keys to any of supported formats.

 

Keys management tools are also available through the Navigation bar of Table Editor.

 

Table Editor - Constraints - Unique keys

 

The Uniques list provides the following attributes of each unique constraint of the table:

Name

On Field(s)

Index Name

Sorting

Description

 

For details see Unique constraints.

 

If necessary, you can also use the Constraint Description area to supply a description for each unique constraint.