system.database_engines

​

Description

​

Columns

• name (String) — The name of database engine.
• description (String) — A high-level description of what the database engine does.
• syntax (String) — How the database engine is specified in the ENGINE clause of a CREATE DATABASE query.
• examples (String) — Usage examples.
• introduced_in (String) — The ClickHouse version in which the database engine was first introduced, in the form major.minor.
• related (Array(String)) — The names of related database engines.

​

Example

SELECT name
FROM system.database_engines
WHERE name IN ('Atomic', 'Ordinary')
ORDER BY name

┌─name─────┐
│ Atomic   │
│ Ordinary │
└──────────┘