Creating a field¶
Fields are created using the “
Create a field” command on a table.
The following properties can be defined for a field in the SQL tab:
- Name: Name of the field.
- Key: Indicates the type of the attribut (Field).
- Type: The SQL type of the field.
- Default value: A default value for the field (editable field).
- Not null: The SQL NOT NULL property
- Autogenerated: The SQL AUTO_INCREMENT property
- Unique: The SQL UNIQUE property
- Null: The SQL NULL property
- Check:The SQL CHECK property