Table fields are managed on the Fields tab of the Table Designer. Just simply click a field for editing. A right-click displays the popup menu or using the toolbar below, allowing you to create new, insert, move and drop the selected field.

Add Field

To add a field to the table

• Open the table in the Table Designer.
• Open the Fields tab.
• Right-click and select the Add Field from the popup menu or click the Add Field from the toolbar.
• Edit field properties.

To add a new field with modification as one of the existing fields

• Open the table in the Table Designer.
• Open the Fields tab.
• Select field.
• Right-click and select the Duplicate Field from the popup menu.
• Edit field properties.

Insert Field

To insert a field above an existing field

• Open the table in the Table Designer.
• Open the Fields tab.
• Select field.
• Right-click and select the Insert Field from the popup menu or click the Insert Field from the toolbar.
• Define field properties in the empty row.

Note: Support from MySQL 3.22 or later.

Edit Field

To edit the table field

• Open the table in the Table Designer.
• Open the Fields tab.
• Simply click on the field to edit.

To change the order of the table fields

• Open the table in the Table Designer.
• Open the Fields tab.
• Right-click on the field to move and select the Move Up/ Move Down from the popup menu or click the Move Up/ Move Down from the toolbar.

Note: Support from MySQL 4.0.1 or later.

Delete Field

To delete the table field

• Open the table in the Table Designer.
• Open the Fields tab.
• Right-click on the field to delete and select the Delete Field from the popup menu or click the Delete Field from the toolbar.
• Confirm deleting in the dialog window.

See also:
Setting Field Name and Data Type
Setting Field Size and Decimals
Setting Field Flags
Setting Other Field Properties