system.functions

Contains information about normal and aggregate functions.

Columns:

• name (String) — The name of the function.
• is_aggregate (UInt8) — Whether the function is an aggregate function.
• case_insensitive (UInt8) — Whether the function name can be used case-insensitively.
• alias_to (String) — The original function name, if the function name is an alias.
• create_query (String) — Obsolete.
• origin (Enum8('System' = 0, 'SQLUserDefined' = 1, 'ExecutableUserDefined' = 2)) — Obsolete.
• description (String) — A high-level description what the function does.
• syntax (String) — Signature of the function.
• arguments (String) — The function arguments.
• parameters (String) — The function parameters (only for aggregate function).
• returned_value (String) — What does the function return.
• examples (String) — Usage example.
• introduced_in (String) — ClickHouse version in which the function was first introduced.
• categories (String) — The category of the function.

Example

 SELECT name, is_aggregate, is_deterministic, case_insensitive, alias_to FROM system.functions LIMIT 5;

┌─name─────────────────────┬─is_aggregate─┬─is_deterministic─┬─case_insensitive─┬─alias_to─┐
│ BLAKE3                   │            0 │                1 │                0 │          │
│ sipHash128Reference      │            0 │                1 │                0 │          │
│ mapExtractKeyLike        │            0 │                1 │                0 │          │
│ sipHash128ReferenceKeyed │            0 │                1 │                0 │          │
│ mapPartialSort           │            0 │                1 │                0 │          │
└──────────────────────────┴──────────────┴──────────────────┴──────────────────┴──────────┘

5 rows in set. Elapsed: 0.002 sec.