Help Center/
MapReduce Service/
Component Operation Guide (ME-Abu Dhabi Region)/
Using ClickHouse/
Common ClickHouse SQL Syntax/
DESC: Querying a Table Structure
Updated on 2024-07-19 GMT+08:00
DESC: Querying a Table Structure
This section describes the basic syntax and usage of the SQL statement for querying a table structure in ClickHouse.
Basic Syntax
DESC|DESCRIBE TABLE [database_name.]table [INTO OUTFILE filename] [FORMAT format]
Example
-- Query the t1 table structure. desc t1; ┌─name────┬─type─┬─default_type─┬─default_expression ┬─comment─┬─codec_expression─┬─ttl_expression─┐ │ id │ UInt8 │ │ │ │ │ │ │ name │ UInt8 │ │ │ │ │ │ │ address │ String │ │ │ │ │ │ └───────┴────┴────────┴────────── ┴───── ┴──────────┴─────────┘
Parent topic: Common ClickHouse SQL Syntax
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