SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA='dbName'
Fuente: http://stackoverflow.com/questions/3913620/get-all-table-names-of-a-particular-database-by-sql-query
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA='dbName'
Fuente: http://stackoverflow.com/questions/3913620/get-all-table-names-of-a-particular-database-by-sql-query