Table Editor.

With Table Editor you can create not only table fields, but also all type of table constraints. Table Fields list are located at "Fields" tab. Table constraints are located at "constraints" tab respectively. Only primary key can be managed from the "Fields" tab. Any dialogs for fields and constraints will be discussed below as a subset of Table Editor.

Field Editor.

Field Editor contains all field parameters required to create table field. Except this, you can provide field description that will be stored later when compiling the database.

When you editing the existing field you can use "Keep Data" flag. When you have table filled with data and you need to change field parameters, you may check the flag "Keep Data". When compiling the table, IBAdmin will try to determine all objects, depended from this field and build special "update" script, that will carefully change field and keeps the data in it.

Foreign Key Editor.

When creating the foreign key you have to select fields for the foreign key and select the references table. If the references table containts not only primary key, but some unique constraints, you can select the constraint name in the referenced table to reference to. "On Delete" and "On Update" options can be selected also.

Index Editor.

Just select fields and check "Unique" and "Descending" flags if needed.

Unique Editor.

Just select desired fields.

Check Editor.

Enter the check statement. "CHECK" reserved word will be added automatically, so do not enter it.