SHOW_VARIABLES

Introduced or updated: v1.2.634

Displays all session variables and their details, such as names, values, and types.

See also: SHOW VARIABLES

Syntax

SHOW_VARIABLES()

Examples

SELECT name, value, type FROM SHOW_VARIABLES();

┌──────────────────────────┐
│  name  │  value │  type  │
├────────┼────────┼────────┤
│ y      │ 'yy'   │ String │
│ b      │ 55     │ UInt8  │
│ x      │ 'xx'   │ String │
│ a      │ 3      │ UInt8  │
└──────────────────────────┘