Manipulating Constraints
Constraints could be added or deleted using following syntax:
ALTER TABLE [db].name ADD CONSTRAINT constraint_name CHECK expression;
ALTER TABLE [db].name DROP CONSTRAINT constraint_name;
See more on constraints.
Queries will add or remove metadata about constraints from table so they are processed immediately.
Warning
Constraint check will not be executed on existing data if it was added.
All changes on replicated tables are broadcasted to ZooKeeper and will be applied on other replicas as well.
当前内容版权归 ClickHouse 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ClickHouse .