Tables editor (MySQL)

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
Columns	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.
Properties	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.
Indexes	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.
Privileges	For details on using this tab, see Working with Privileges and Permissions.
Space	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.