mysqlstorage-engines

Show tables by engine in MySQL


How would I show all tables in MySQL with a given engine, e.g. InnoDB, MyISAM, FEDERATED?


Solution

  • Use INFORMATION_SCHEMA.TABLES table:

    SELECT table_name FROM INFORMATION_SCHEMA.TABLES
      WHERE engine = 'InnoDB'