MySQL: Two more ways to find out table storage engine

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;

No Comment

No comments yet

Leave a reply