Fields

Table fields are managed on the Fields tab of the Table Editor. You can also access the table fields via the Databases tab of the DB Explorer (if option Show Table Subobjects is on) or via the SQL Assistant area (if the Tables' Details switch is set to Show Fields).

Add Field

To add a field to the table

1

Open the table in the Table Editor.

2

Open the Fields tab.

3

Right-click and select the New Field item from the popup menu (sets the Insert Mode to Insert Last in the Field Editor).

or

3   Select the field in the list to insert the new field after.

4   Right-click and select the Insert Field item from the popup menu (sets the Insert Mode to Insert After in the Field Editor).

Any of the above actions opens the Field Editor dialog. Set the field properties and select the Insert Mode to define the position of the new field in the table field list if necessary.

Edit Field

To edit the table field

1

Open the table in the Table Editor.

2

Open the Fields tab.

3

Double-click the field to edit.

or

4   Right-click on the field and select the Edit Field <Field_Name>   item from the popup menu.

Now the field is available for editing in the Field Editor dialog.

To change the order of the table fields

1

Open the table in the Table Editor.

2

Open the Fields tab.

3

Right-click and select the Reorder Fields item from the popup menu.

This opens the Re-order Columns window for changing the field order.

Drop Field

      
To drop the table field

1

Open the table in the Table Editor.

2

Open the Fields tab.

3

Right-click on the field to drop and select the Drop Field item from the popup menu.