table_schema and table_name in db

SELECT table_schema,table_name FROM information_schema.tables ORDER BY table_schema,table_name;