v.18.4New Feature
Added System Tables: formats, data_type_families, aggregate_function_combinators, table_functions, table_engines, collations
Added system tables:formats,data_type_families,aggregate_function_combinators,table_functions,table_engines,collations#2721.
Why it matters
These system tables allow users and administrators to easily query and explore available data formats, data type categories, aggregate function combinators, table functions, table engines, and collations within ClickHouse. This improves the transparency of internal components and helps in writing more informed queries and managing database configurations.How to use it
Users can query these new system tables directly usingSELECT statements, for example:SELECT FROM system.formats;
SELECT FROM system.table_engines;These tables are accessible without any additional configuration, providing immediate insight into the respective categories.