How to Edit Columns

Top Previous Next

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
Properties Pane
Button Pane.

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;

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;

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:

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

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;

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;

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

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

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;

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

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 a new column with the default properties to the end of the list;

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

Remove the selected column from the list;

Move the selected column along the list.

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