system.columns

    • database (String) — Database name.
    • table () — Table name.
    • name (String) — Column name.
    • type () — Column type.
    • position (UInt64) — Ordinal position of a column in a table starting with 1.
    • default_kind () — Expression type (DEFAULT, MATERIALIZED, ALIAS) for the default value, or an empty string if it is not defined.
    • default_expression (String) — Expression for the default value, or an empty string if it is not defined.
    • data_compressed_bytes () — The size of compressed data, in bytes.
    • data_uncompressed_bytes (UInt64) — The size of decompressed data, in bytes.
    • marks_bytes () — The size of marks, in bytes.
    • comment (String) — Comment on the column, or an empty string if it is not defined.
    • is_in_partition_key () — 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 () — 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.
    • () — Compression codec name.
    1. Row 1:
    2. database:                system
    3. table:                   aggregate_function_combinators
    4. name:                    name
    5. type:                    String
    6. default_kind:            
    7. default_expression:      
    8. data_compressed_bytes:   0
    9. data_uncompressed_bytes: 0
    10. marks_bytes:             0
    11. comment:                 
    12. is_in_partition_key:     0
    13. is_in_sorting_key:       0
    14. is_in_primary_key:       0
    15. is_in_sampling_key:      0
    16. compression_codec:       
    19. database:                system
    20. table:                   aggregate_function_combinators
    21. name:                    is_internal
    22. type:                    UInt8
    23. default_kind:            
    24. default_expression:      
    25. data_compressed_bytes:   0
    26. data_uncompressed_bytes: 0
    27. marks_bytes:             0
    28. comment:                 
    29. is_in_partition_key:     0
    30. is_in_sorting_key:       0
    31. is_in_primary_key:       0
    32. is_in_sampling_key:      0
    33. compression_codec:       
    35. 2 rows in set. Elapsed: 0.002 sec.