MySQL: Two more ways to find out table storage engine
Posted October 4, 2009 
Comments(0)
Comments(0) In addition to SHOW TABLE STATUS there are at least two more ways to find out a table storage engine.
The first way is simply to query the INFORMATION_SCHEMA.TABLES.
SELECT `table_name`, `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE(); |
In case there is not permission to access INFORMATION_SCHEMA the second way requires only the SELECT privilege for the table.
SHOW CREATE TABLE TestTable; |