CheckMySQL Engine of database table

CheckMySQL Engine of database table

For a specific table:

SHOW TABLE STATUS WHERE Name = 'table_name';

For all tables of the specific database:

SELECT TABLE_NAME,
ENGINE
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'database_name';

Or you can use this simple command, this will list all tables:

SHOW TABLE STATUS;