Tables editor (MySQL)

From DBArtisan
Jump to: navigation, search

Go Up to MySQL editors

The MySQL Tables editor lets you modify basic properties and view usage statistics for a MySQL table.

To edit a table:

  1. Open an editor on the index. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Displays the currently defined columns in the table. Optionally, you can:

Select a column, and in the Property/Value list modify property values for that column.

Click Add Column, provide a name for the new column, and set property values for the column.

Select a column and click Delete to remove the column from the table.


Lets you work with the following settings: Table Name, Storage Type, Row Format, Default Character Set, Default Collation, Auto Increment, Comment, Min Rows, Max Rows, Average Row Length, Pack Keys, Checksum, and Delay Key Write. For details on these properties, see Tables - Properties.


Lets you add, delete, or modify table indexes. For details on available options, see Tables - Indexes.

Foreign Keys

For INNODB tables, this tab lets you add, delete, or modify table foreign keys. For details on available options, see Tables - Foreign Keys.

MERGE tables

For MRG_MyISAM tables, this tab lets you work with the collection of identical MyISAM tables that are to be used as a single table. For more information, see Tables - MERGE Tables.


For details on using this tab, see Working with Privileges and Permissions.


Lets you view graphical and numerical table usage statistics. Values include Data Length, Index Length, Data Free, Max Data Length, Rows, and Average Row Length.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.