Skip to main content
Skip to main content

Manipulating Constraints

Constraints could be added or deleted using following syntax:

See more on constraints.

Queries will add or remove metadata about constraints from table, so they are processed immediately.

tip

Constraint check will not be executed on existing data if it was added.

All changes on replicated tables are broadcast to ZooKeeper and will be applied on other replicas as well.

Try ClickHouse Cloud for FREE

Separation of storage and compute, automatic scaling, built-in SQL console, and lots more. $300 in free credits when signing up.

Try it for Free