How to Edit Columns

The Column Editor is placed within the Table Editor dialog. It allows you to modify the list of table columns as well as column properties. Click the Columns tab of the Table Editor to manage table columns.

The Column Editor consists of the following areas:

Column List

The column list displays all the columns in the table and allows you to modify the following column properties:

Column name
The name of the column, which must be unique within the table;

Data type
The type of the column, which specifies data to store in the column;

Domain
You can specify a column domain, see the Domains topic for detailed information;

Primary key
Specify this option to include the field into the table primary key;

Comment
An arbitrary description for the column.

Properties Pane

The properties pane allows you to define the advanced properties of the column, selected in the Column List. The appearance of this pane changes according to the data type of the column. These properties are:

Length
This attribute defines the maximum allowed length of the stored values; it applies to all integer, decimal, and string types;

Decimals
This attribute defines the number of digits, which follow the decimal point;

Not null
This option indicates that the stored column value cannot be NULL;

Autoinc
This attribute makes the column value autoincrement, i.e. each new value is set automatically according to the previous value; it applies to all integer values;

Binary
This attribute indicates that the string value is stored in a binary form within the column;

Unsigned
This option indicates that the stored integer or decimal value must be above zero;

Zerofill
With this attribute all unspecified digits of the field value are filled as zeros according to the column length and decimals; it applies to all integer and decimal types;

Set
This attribute defines the list of permissible values for the field of the ENUM or SET type;

Default
This attribute defines the default value, which the column accepts if no other is specified.

Buttons Pane

The buttons under the list of columns allow you to perform the following actions:

Add
Add a new column with the default properties to the end of the list;

Duplicate
Add a new column with the same properties as the selected column to the end of the list;

Delete
Remove the selected column from the list;

Up/Down
Move the selected column along the list.

See also:
Diagram Objects: Domains | Table Editor | Indexes | Triggers | Column Manager