Help Center/
CloudTable Service/
User Guide/
Using ClickHouse/
Common SQL Commands for Storage-Compute Coupled ClickHouse/
DESC|DESCRIBE TABLE
Updated on 2025-07-24 GMT+08:00
DESC|DESCRIBE TABLE
This section describes the basic syntax and usage of the SQL statement for querying the table structure in ClickHouse.
Basic Syntax
DESC|DESCRIBE TABLE [database_name.]table [INTO OUTFILE filename] [FORMAT format]
Query the structures of tables demo_t and demo_2 by referring to Creating a Table by Copying the Structure of an Existing Table.
cloudtable-wlr-click-20230730-06-server-1-1 :) desc demo_t; DESCRIBE TABLE demo_t Query id: 27a38d90-9459-430f-962e-881817789fc9 ┌─name───┬─type───┬─default_type─┬─default_expression─┬─comment─┬─codec_expression─┬─ttl_expression─┐ │ uid │ Int32 │ │ │ │ │ │ │ name │ String │ │ │ │ │ │ │ age │ UInt32 │ │ │ │ │ │ │ gender │ String │ │ │ │ │ │ └────────┴────────┴──────────────┴────────────────────┴─────────┴──────────────────┴────────────────┘ 4 rows in set. Elapsed: 0.001 sec. cloudtable-wlr-click-20230730-06-server-1-1 :) desc demo_t2; DESCRIBE TABLE demo_t2 Query id: 60054fe3-794c-410a-be13-cd0b204a9129 ┌─name───┬─type───┬─default_type─┬─default_expression─┬─comment─┬─codec_expression─┬─ttl_expression─┐ │ uid │ Int32 │ │ │ │ │ │ │ name │ String │ │ │ │ │ │ │ age │ UInt32 │ │ │ │ │ │ │ gender │ String │ │ │ │ │ │ └────────┴────────┴──────────────┴────────────────────┴─────────┴──────────────────┴────────────────┘ 4 rows in set. Elapsed: 0.001 sec.
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