Help Center> MapReduce Service> Component Operation Guide> Using ClickHouse> Common ClickHouse SQL Syntax> DESC: Querying a Table Structure
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
Last Article: ALTER TABLE: Modifying a Table Structure
Next Article: DROP: Deleting a Table
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.