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.
