To bring up Table Properties select the table and right-click to activate the context menu. Select Properties. The Table Properties dockable window will be displayed.
The following table properties are listed under table properties, and many are fully described in the SHOW TABLE STATUS MySQL documentation.
Auto Increment: The next
Average Row Length: The
Character Set: The Charset value.
Collation: The Collation value.
Comment: Table comments.
Data Directory: The directory used to store data files for this table.
Index Directory: The directory used to store index files for this table.
Maximum Rows: Value of the
Minimum Rows: Value of the
Name: Name of the table.
Row Format: The
Schema: The schema this table belongs to.
In MySQL 5.5 and higher, the default storage engine for
new tables is
InnoDB as the Default MySQL Storage Engine for more information
about the choice of storage engine, and considerations
when converting existing tables to
Schema is read-only.
Copyright © 2004, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices