Get all tables from a given schema

      
SELECT t.table_name
FROM information_schema.tables t
WHERE t.table_schema = 'mySchema'
ORDER BY 1