mysql lookup table schema

Question

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.

Answer 1

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