CREATE - ClickHouse Documentation

CREATE queries create (for example) new databases, tables and views. Syntax

CREATE DATABASE ...
CREATE TABLE ...
CREATE VIEW ...
CREATE DICTIONARY ...
CREATE FUNCTION ...
CREATE NAMED COLLECTION ...
CREATE USER | ROLE | ROW POLICY | MASKING POLICY | QUOTA | SETTINGS PROFILE ...

Related: ATTACH, DROP, CREATE TABLE, CREATE DATABASE, CREATE VIEW, CREATE DICTIONARY

Last modified on August 25, 2026