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_%';

Last updated