Added SHOW CREATE DATABASE Query

Published: November 25, 2025

Added the SHOW CREATE DATABASE query.

Introduced the SHOW CREATE DATABASE query in ClickHouse.

Why it matters

This feature allows users to retrieve the exact DDL statement used to create a database, facilitating easier database management, migration, and backup by providing a clear definition of the database structure.

How to use it

Execute the query:

SHOW CREATE DATABASE database_name;

replacing database_name with the name of the database you want to see the creation statement for.