Get All Tables in MySQL

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;