SHOW TABLES statement

Synopsis

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

Syntax diagram

Read syntax diagramSkip visual syntax diagram SHOW TABLESFROMschemaLIKE pattern ESCAPE 'escape_character'

For information on reading syntax diagrams, see How to read syntax diagrams

Description

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