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."