Skip to main content

SHOW TABLES

Use the SHOW TABLES command to view tables in a particular schema.

Syntax

SHOW TABLES [FROM schema_name];

Parameters

ParameterDescription
schema_nameThe schema in which tables will be listed. If not given, tables from the default schema, "public", will be listed.

Example

SHOW TABLES FROM schema_1;

Help us make this doc better!