Skip to content

SHOW Statement#

The SHOW statement is used to list tables in a catalog.

Syntax#

1
SHOW TABLES [ {FROM|IN} <catalog> ] [ LIKE <pattern> ]
Parameter Description
<catalog> catalog name
<pattern> pattern string to match e.g. a table prefix

Note

Pattern support is currently dependent upon the underlying catalog's list support. For example, Iceberg and S3 Tables list by prefix rather than with a regular expression. Please see issue #4007 for better pattern support.

Examples#

Show tables in the current catalog.

1
SHOW TABLES;

Show tables in the current catalog matching the pattern.

1
SHOW TABLES LIKE 'foo'

Show tables in catalog my_catalog.

1
SHOW TABLES IN my_catalog;

Show tables in catalog my_catalog matching the pattern.

1
SHOW TABLES IN my_catalog LIKE 'foo';