Skip to main content
Skip to main content
Edit this page

system.database_engines

Description​

Contains the list of database engines supported by the server.

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 │
└──────────┘