SHOW TABLES

Lists the tables and views you can access.

Syntax

SHOW [ FULL ] TABLES [ IN <schema_name> ]

Parameters

FULL

Includes partitioning, deduplication, row counts, and storage statistics in addition to names, types, and comments. Statistics may be NULL when unavailable.

<schema_name>

Optional schema to list. If omitted, lists tables across all schemas you can access.

Examples

List tables in the public schema:

SHOW TABLES IN public