The following content of this documentation page has been machine-translated. But unlike other websites, it is not done on the fly. This translated text lives on GitHub repository alongside main ClickHouse codebase and waits for fellow native speakers to make it more human-readable.

系统。列

包含有关所有表中列的信息。

该 表包含以下列（列类型显示在括号中):

• database (String) — Database name.
• table (String) — Table name.
• name (String) — Column name.
• type (String) — Column type.
• default_expression (String) — Expression for the default value, or an empty string if it is not defined.
• data_compressed_bytes (UInt64) — The size of compressed data, in bytes.
• data_uncompressed_bytes (UInt64) — The size of decompressed data, in bytes.
• (UInt64) — The size of marks, in bytes.
• is_in_partition_key (UInt8) — Flag that indicates whether the column is in the partition expression.
• is_in_sorting_key (UInt8) — Flag that indicates whether the column is in the sorting key expression.
• is_in_primary_key (UInt8) — Flag that indicates whether the column is in the primary key expression.
• is_in_sampling_key (UInt8) — Flag that indicates whether the column is in the sampling key expression.