To bring up Table Properties select the table and right-click to activate the context menu. Select Table Properties dockable window will be displayed.. The
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. See 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.