Skip to main content

SHOW TABLES

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

Syntax

SHOW TABLES [ FROM schema_name ] [ LIKE_expression ];

Parameters

Parameter or clauseDescription
schema_nameThe schema in which tables will be listed. If not given, tables from the default schema, public, will be listed.
LIKE_expressionFilters the output based on names by applying pattern matching. See details in LIKE pattern matching expressions.

Example

SHOW TABLES FROM public LIKE 't_';
t1

Help us make this doc better!