The MySQL Table Editor consists of a work space divided into three tabs, some general information prompts, and three action buttons.
Regardless of the tab you have active, you can always edit the table name, the database it belongs to, and the table comment.
The tabbed area is divided into three sections:
Columns and Indices: Use the Columns and Indices tab to create and modify the table's column and index information. You can also create FOREIGN KEY relationships using this tab.
Table Options:Use the Table Options tab to choose the storage engine used by the table and the table's default character set.
Advanced Options: Use the Advanced Options tab to configure advanced options such as per-table storage directory, MERGE and RAID table options, and table/row length options.
Each of these areas are discussed in further detail in the following sections.
