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.
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