SHOW TABLES

Synopsis

SHOW TABLES [ FROM schema ] [ LIKE pattern ]

Description

List the tables in schema or in the current schema.

Specify a pattern in the optional LIKE clause to filter the results to the desired subset.. For example, the following query allows you to find tables that begin with p:

SHOW TABLES FROM tpch.tiny LIKE 'p%';