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;