/* Within MySQL Shell you can use this: */ SELECT table_schema, table_name, engine FROM information_schema.tables WHERE engine='myisam' AND table_schema NOT IN ('mysql','performance_schema','information_schema'); /* This will list all tables using MyISAM excluding default mysql table schemas. */