mysqlschemastorage-engines

mysql lookup table schema


What's a more detailed command for seeing table properties than show tables? In particular, I need to know what storage engines are being used in a database that I've inherited.


Solution

  • You could query the information_schema tables directly.

    SELECT `table_name`, `engine`
    FROM `information_schema`.`tables`
    WHERE `table_schema` = 'your_db'
    ORDER BY `table_name` ASC