7.1.11 The MySQL Table Editor

7.1.11.1 The Main Editor Window
7.1.11.2 The Columns Tab
7.1.11.3 The Indexes Tab
7.1.11.4 The Foreign Keys Tab
7.1.11.5 The Triggers Tab
7.1.11.6 The Partitioning Tab
7.1.11.7 The Options Tab

The MySQL Table Editor is a component that enables the creation and modification of tables. You can add or modify a table's columns or indexes, change the engine, add foreign keys, or alter the table's name.

The MySQL Table Editor can be accessed in several ways, and most commonly by right-clicking on a table name within the Object Viewer and choosing ALTER TABLE. This will open a new tab within the main SQL Editor window. You can also access the MySQL Table Editor from an EER Diagram by double-clicking a table object.