MySQL Detailed Table Information

Use the following query to view detailed information about each table in the specified database:

SHOW TABLE STATUS FROM `database`;

Explanation

The SHOW TABLE STATUS command will show the following information about each table in the specified database:

• Name
• Engine
• Version
• Row Format
• Rows
• Average Row Length
• Data Length
• Max Data Length
• Index Length
• Data Free
• Auto Increment
• Create Time
• Update Time
• Check Time
• Collation
• Checksum
• Create Options
• Comment

Replace database with the name of your database.