SHOW

Syntax

Showing a Table Example

SHOW TABLE [ LIKE { pattern } ]

Parameters

• [ LIKE ] The pattern match is case-insensitive but must be used with the LIKE operator.

Examples

Show all existing tables.

SHOW TABLES;

Show an existing table with the exact name.

SHOW TABLES LIKE 'eth.recent_blocks';

Show all existing tables with names that start with protect_.

SHOW TABLES LIKE 'eth.recent_%';