Find which tables use INNODB with MySQL
by Rekha[ Edit ] 2010-01-28 14:26:16
The SQL to do this queries the INFORMATION_SCHEMA and is as follows:
SELECT table_schema, table_name
FROM INFORMATION_SCHEMA.TABLES
WHERE engine = 'innodb';
table_schema is the name of the database.
table_name is (obviously) the name of the table.
The above query will list the table names whose engine is innodb.
