On this page

SHOW: Displaying Information About Databases and Tables

Updated on 2022-11-18 GMT+08:00

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

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback