SHOW TABLES

Synopsis

SHOW TABLES [ FROM schema ] [ LIKE pattern [ ESCAPE 'escape_character' ] ]

Description

List the tables in schema or in the current schema. The LIKE clause can be used to restrict the list of table names.