Kit Peters Kit Peters - 1 year ago 142
MySQL Question

Show tables by engine in MySQL

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

Answer Source

Use INFORMATION_SCHEMA.TABLES table:

SELECT table_name FROM INFORMATION_SCHEMA.TABLES
  WHERE engine = 'InnoDB'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download