List InnoDB tables in MySQL database

Article for: MariaDB

The query below lists all InnoDB tables in all user databases. To list MyISAM tables from current database use this query.


select table_schema as database_name,
from information_schema.tables tab
where engine = 'InnoDB'
      and table_type = 'BASE TABLE'
      and table_schema not in ('information_schema', 'sys',
      -- and table_schema = 'your database name'
order by table_schema,


  • database_name - database (schema) name
  • table_name - table name


  • One row: represents one table in a database (schema)
  • Scope of rows: all tables which uses InnoDB as storage engine in all databases (schemas)
  • Ordered by: database name, table name

Sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.