Find which tables use INNODB

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’;

where:
table_schema is the name of the database.
table_name is (obviously) the name of the table.

Comments are closed.