Skip to content

Latest commit

 

History

History
33 lines (25 loc) · 677 Bytes

show.md

File metadata and controls

33 lines (25 loc) · 677 Bytes

SHOW

Syntax

{% code title="Showing a Table Example" %}

SHOW TABLE [ LIKE { pattern } ]

{% endcode %}

Parameters

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

Examples

{% code title="Show all existing tables." %}

SHOW TABLES;

{% endcode %}

{% code title="Show an existing table with the exact name." %}

SHOW TABLES LIKE 'eth.recent_blocks';

{% endcode %}

{% code title="Show all existing tables with names that start with protect_." %}

SHOW TABLES LIKE 'eth.recent_%';

{% endcode %}