SELECT `TABLE_NAME`
FROM  `INFORMATION_SCHEMA`.`TABLES` 
WHERE `TABLE_SCHEMA` = 'schema'

SELECT `TABLE_NAME`, `COLUMN_NAME`
FROM `INFORMATION_SCHEMA`.`COLUMNS`
WHERE `TABLE_SCHEMA` = 'schema'
ORDER BY `TABLE_NAME`, `COLUMN_NAME`