MySQL Workbench Indexes Tab

The Indexes subtab contains all of the index information for your table. Use this subtab to add, drop, and modify indexes. The following figure shows an example of the layout with the PRIMARY index of the customer table selected and both the index columns and index options shown.

Figure 8.15 The Indexes Tab

Content is described in the surrounding text.

All indexes for a table are listed by index name. Click an index name to display the Index Columns section with information about the selected index. In addition, you can configure the storage type, key block size, parser, and the visibility of the index. Index comments, when added, apply to the selected index only.

The actions available from this subtab include: