select a.table_id,a.name,b.name,b.type from
information_schema.INNODB_SYS_TABLES a left outer join information_schema.INNODB_SYS_INDEXES b on a.table_id=b.table_id and b.type in (2)
where a.name like 'smart_park%'
order by a.name
information_schema.INNODB_SYS_TABLES a left outer join information_schema.INNODB_SYS_INDEXES b on a.table_id=b.table_id and b.type in (2)
where a.name like 'smart_park%'
order by a.name