ContextQMD
Back to Clickhouse

CREATE NAMED COLLECTION

docs/en/sql-reference/statements/create/named-collection.md

26.4.1.1-new738 B
Original Source

import CloudNotSupportedBadge from '@theme/badges/CloudNotSupportedBadge';

<CloudNotSupportedBadge />

CREATE NAMED COLLECTION

Creates a new named collection.

Syntax

sql
CREATE NAMED COLLECTION [IF NOT EXISTS] name [ON CLUSTER cluster] AS
key_name1 = 'some value' [[NOT] OVERRIDABLE],
key_name2 = 'some value' [[NOT] OVERRIDABLE],
key_name3 = 'some value' [[NOT] OVERRIDABLE],
...

Example

sql
CREATE NAMED COLLECTION foobar AS a = '1', b = '2' OVERRIDABLE;

Related statements

See Also