Help Center/
CloudTable Service/
User Guide/
Using ClickHouse/
Common SQL Commands for Storage-Compute Coupled ClickHouse/
SHOW
Updated on 2025-07-24 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;
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot