Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using ClickHouse/ Common ClickHouse SQL Syntax/ SHOW: Displaying Information About Databases and Tables
Updated on 2022-11-18 GMT+08:00
View PDF

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    │
└─────┘