Updated on 2024-07-19 GMT+08:00

SHOW: Displaying Information About Databases and Tables

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

Example

-- Query database information.
show databases;
┌─name────┐
│ default      │
│ system       │
│ test         │
└───────┘
-- Query table information.
show tables;
┌─name──┐
│ t1       │
│ test     │
│ test2    │
│ test5    │
└─────┘