SHOW TABLES

Core command SH TA SHTA

Displays the tables (not the views) whose schema and name match the entered pattern

Arguments

<tableName> (optional) a schema and name separated by a dot (.). Schema name is optional

Examples

SHOW TABLES;
SHOW TABLES CUSTOMER;
SHOW TABLES CUSTOM%;
SHOW TABLES PUBLIC.CUSTOMER;
SHOW TABLES PUB%.CUSTOMER;
SHOW TABLES PUB%.%STOME%;

Notes

Lists tables matching a pattern: SHOW TABLES [[schema.]namePattern].

Both the schema and table parts (separated by a dot, schema optional) are always treated as a "contains" search - each is internally wrapped in %...% - so SHOW TABLES CUSTOMER; finds CUSTOMER, CUSTOMERS and OLD_CUSTOMER alike, with no need to type the % yourself. Whether the match is case-sensitive depends on the connected database.

If the table part is omitted entirely, all tables are listed. If the schema part is omitted, the search is restricted to the connection's <em>current</em> schema, not every schema.

Only tables are listed: ordinary tables, the temporary tables the database reports (H2 does not report its local temporary tables) and, in a system schema, system tables. Views and materialized views are listed by SHOW VIEWS. Synonyms, sequences, indexes, types and other objects the database reports are not listed.

Last modified in release 5.3.2.