The Schema Tables tab lists the different tables in the selected database, along with the rowcount, data length, and index length for those tables. For MyISAM tables, you also find the date and time when the table was last modified, under Update Time. You can update the list of tables by pressing the Refresh button.

The tables are ordered by table name initially, but you may change that sorting by clicking on the appropriate headings (Type, Row Format, etc.).

To drop a table, right click on the table and choose the Drop Table option from the pop-up menu. To create a table you can either click the Create Table button at the bottom of the window, or right-click on a table and choose the Create Table option from the pop-up menu.

To edit a table's columns and indexes, right-click on the desired table and choose the Edit Table option from the pop-up menu. This will launch the MySQL Table Editor, which you can use to modify the table. For more information, see Chapter 20, The MySQL Table Editor .

To edit a table's actual data, right click on the table and choose the Edit Table Data option. This will launch the MySQL Query Browser and load the table's data into the result area of the MySQL Query Browser.

To perform operations on multiple tables select more than one table. For the selected tables, you can perform operations by either clicking the Maintenance button at the bottom of the table list or by right clicking on one of the selected tables and choosing from the Maintenance sub-menu of the pop-up menu:

The available options are:

Clicking on a table name will display its properties in the details area when the details area is active. To display the details area, click the Details >> button.