Skip navigation links
MySQL Administrator :: 20 The MySQL Table Editor :: 20.2 The Main Editor Window
20.3 The Columns And Indices Tab »
Section Navigation      [Toggle]

20.2. The Main Editor Window

The MySQL Table Editor consists of a work space divided into tabs, some general information prompts, and two or three action buttons.

Regardless of the active tab, you can always edit the table name and the table comment.

Figure 20.1. The MySQL Table Editor

The MySQL Table Editor

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 and default character set used by the table.

  • Advanced Options: Use the Advanced Options tab to configure options such as the 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.