Question

SQL SERVER中如何更改CHECK约束？

Answer 1

好像没有修改约束，你可以先删除约束，再添加约束
添加约束

ALTER
TABLE employees

ADD
CONSTRAINT emp_manager_fk

FOREIGN
KEY(manager_id)

REFERENCES
employees(employee_id);

删除约束

ALTER
TABLE employees

DROP
CONSTRAINT emp_manager_fk;