Get all Tables of a specific schema in MySQL.
SELECT table_name as 'Table Name' FROM information_schema.TABLES WHERE table_schema = '$DATABASE_NAME';
Get all tables of all schemas in MySQL.
SELECT table_name as 'Table Name' FROM information_schema.TABLES;