Updated on 2024-04-29 GMT+08:00

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;