SHOW TABLES

Core command SH TA SHTA

Display all tables which 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.

Last modified in release 4.9.8.