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;