Tools - MySQL Database Servers - Table Properties

You will open the MySQL "Table Properties" window using the command of the same name in the pop-up menu opened by right-clicking on the table name in the database structure tree of the MySQL Inspector tab.

Table name
This field contains the name of the current table. By clicking the button next to it, you can bring up a window that allows you to enter a new name, which allows you to change the name of the table you are editing.

The two tabs below - Table Fields and Table Indexes - allow you to edit the table.

Table Fields tab

The "Table fields" tab lists the fields that the table contains and the button bar.

The list of fields contains four columns that display:

• Field name with the icon next to it. A small square marks the fields that existed before editing, the larger (colored) fields that were added when editing the table
• Data type, e.g. varchar(50), tinyint(4), enum('y', 'n'), etc.
• Empty, information on whether a NULL value can be stored in the field
• Default value, a value entered into a field when it was not specified directly when creating a new record
• Other, information whether the primary key of the table has an "auto_increment" attribute.

The toolbar next to the list contains buttons that allow you to add, remove and change field properties:

Add a new table field , Change the properties of the selected table field
Both commands open the Table field properties when when editing a selected field, of course its settings will be displayed in the window. You can also open the properties window of the selected field by double-clicking on its name.

Deleting a table field
Deletes a field behind the table. Note - this operation is irreversible, make sure that you want to delete the selected field and that it does not contain any relevant data!

Up, down
Allow you to move the selected field up, or down, the table structure.

Table indexes tab

The "Table Indexes" tab is identical to the "Table Fields" tab described above. It contains a list of indexes and a bar of buttons for adding, deleting and modifying them.

In the list, icons are placed next to the name of the index to indicate its type:

• standard index
• PRIMARY type index
• UNIQUE type index
• FULL TEXT index

When you click on the button to edit or create an index, the Index Properties window will open, where you will be able to select the type of index, the fields to which it applies and enter a name.