MySQL Administrator :: 15.2 Schema Tables

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. See Chapter 16, 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.

You may select more than one table at a time in order to perform operations on multiple tables. For the selected tables, you can perform the following 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 one of the following options from the Maintenance sub-menu of the pop-up menu:

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.