3.4. The MySQL Table Editor

MySQL Query Browser has a table editor facility that enables you to create tables or edit the definitions of existing tables. To access the MySQL Table Editor, right-click on a table name in the database browser and select Edit Table. The MySQL Table Editor also can be accessed from the MySQL Administrator program: Select the Catalogs section of the main window, select a database, and then right-click on a table name and select Edit Table.

The MySQL Table Editor provides a graphic interface for manipulation of table definitions, as shown in Figure 3.2.

Figure 3.2. MySQL Table Editor.

The MySQL Table Editor enables you to perform the following tasks:

• Create new tables or edit the structure of existing tables

• Rename tables or move tables to a different database

• Change table options, such as the storage engine, character set and collation, or table comment

• Specify column definitions (name, data type, and attributes)

• Define indexes and foreign keys

The Options dialog has an Editors section that enables you to set MySQL Table Editor preferences. See Section 3.6, "The Options Dialog."