SQLEditor Icon

Fields

Fields in SQLEditor represent columns within database tables. Fields have properties that can be edited using the inspector. They can also be moved between tables by dragging. Fields are always contained within tables except when being moved.

Tip:
You can also change the data type and some other settings of a field by using the context menu (Right Mouse Button/Control Click)

Fields support direct editing of the field name.

Columns in databases can have various options and SQLEditor supports most of the common options. Icons appear on fields for each option that is set.

The image below shows the table from the table example which has had a field added it to it.

The field shows all of the possible icons that fields can currently have in SQLEditor.

Most fields will not display all of these icons.

You can also add comments for tables and columns

Field Options

Option Icon Description
Primary Key P The field is part of a primary key
Foreign Key F Field is a foreign key and references another field
Auto Increment A Field has an auto incrementing value (in supported databases)
Not Null N The field cannot be Null
Default Value D The field has a default value set
Field Comment ? The field has an attached comment
Indexed I The field is indexed
Zero Fill Z The field is has the Zero Fill option set (for MySQL)
Unsigned +/- The field is has the unsigned option set (for MySQL)
Unique U The field has a unique constraint set on it
Time Zone tz The field is of type timestamp and has a time zone set.