Help Center/CloudTable Service/User Guide/Using ClickHouse/Common SQL Commands for Storage-Compute Coupled ClickHouse/SHOW

Updated on 2025-12-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;
```

Parent topic:Common SQL Commands for Storage-Compute Coupled ClickHouse

Previous topic: DROP

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.