INFORMATION_SCHEMA."TABLES"

The INFORMATION_SCHEMA."TABLES" view contains metadata for the tables and views in a project.

note:

The name of the view must be encapsulated in quotes ("TABLES") so that it is parsed as the view name instead of the reserved keyword tables.

Syntax

SELECT * 
FROM INFORMATION_SCHEMA."TABLES"

{{% snippet "information-schema-tables-snippet.md" %}}