Available columns

Contains a list of columns (fields) of the table being created. For each field following properties are displayed:

Name – name of the table's column;

Type – data type of the column; it is selected from a list containing supported data types of SQL language;

Size – size of the field, which is to be specified for some data types;

Scale – number of digits in fractional part for the data type DECIMAL;

Default value – a value which can be assigned to the field by certain data sources when the record is created;

Can contain NULL value – “yes” or “no”, depending on specific data source.

There are four buttons in the pane:

Add – activates the column properties pane to add a new column to the table;

Delete – deletes the table column selected in the list;

Up, Down – moves the selected column along the list changing its position among the table columns.

Column properties

Displays properties of the selected table column when it is added or modified; allows setting values of properties Name, Type, Size and Scale.

The properties Default value and Can contain NULL value are determined automatically for each specific data source and are not displayed in the pane Column properties.

The button Save transfers values of fields of this pane to a selected row of the table columns' list.