SHOW TABLES¶

List all tables in a schema.

Syntax¶

SHOW TABLES FROM <catalog>.<schema>

SHOW TABLES FROM <catalog>.<schema> LIKE '<pattern>'

Parameter	Description
`catalog`	The Lance catalog name.
`schema`	The schema name.
`pattern`	Optional SQL LIKE pattern to filter table names.

List all tables in a schema:

SHOW TABLES FROM lance.default;

Filter tables by pattern:

SHOW TABLES FROM lance.default LIKE 'user%';

SHOW TABLES FROM lance.analytics LIKE '%_daily';

Returns a single column Table containing the table names.