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

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 databases. 
    show databases;
┌─name────┐
│ default      │
│ system       │
│ test         │
└───────┘
  • Query table information. 
    show tables;
┌─name──┐
│ t1       │
│ test     │
│ test2    │
│ test5    │
└─────┘