Show tables from all schemas in Presto

Question

In Presto

SHOW SCHEMAS; returns all schemas

SHOW TABLES FROM foo; returns all tables for foo schema

Is there a simple way to return tables from all schemas in Presto?

Answer 1

You can use select table_schema, table_name from information_schema.tables;