v.19.14New Feature

Table Constraints

Official CH changelog text
Table constraints. Allows to add constraint to table definition which will be checked at insert. #5273 (Gleb Novikov) #6652 (alexey-milovidov)
Table constraints feature allows users to add constraints to table definitions in ClickHouse, which are checked during data insertion.

Why it matters

This feature provides a way to enforce data integrity by validating inserted data against user-defined constraints. It helps catch invalid or unwanted data at the point of insert, preventing it from being stored in the table.

How to use it

Users can define constraints as part of the table schema during table creation or alteration with the CONSTRAINT clause. These constraints are automatically checked on every insert operation, rejecting rows that do not satisfy the conditions.

Related resources

PreviousNext