Help Center/ CloudTable Service/ User Guide/ Using ClickHouse/ Common SQL Commands for Storage-Compute Coupled ClickHouse/ SHOW
Updated on 2025-07-24 GMT+08:00
View PDF
Share

SHOW

This section describes the basic syntax and usage of the SQL statement for displaying information about databases and tables in ClickHouse.

Basic Syntax

show databases;
show tables;

Examples:

  • Query the database. 
    show databases;
  • Query the table information. 
    show tables;