为已经存在不符合数据约束的表添加约束
1
ALTER Table Customers
2WITH NOCHECK
3
4ADD CONSTRAINT CN_NOCHECK
5CHECK
6(NAME LIKE 'GEEWU%')
ALTER Table Customers2
WITH NOCHECK3
4
ADD CONSTRAINT CN_NOCHECK5
CHECK6
(NAME LIKE 'GEEWU%')临时禁用表的约束（NO CHECK）
1ALTER TABLE Customers
2NOCHECK
3CONSTRAINT CN_GeeWu
ALTER TABLE Customers2
NOCHECK3
CONSTRAINT CN_GeeWu查看禁用表约束 (Watch Table's CHECK)
1EXEC sp_helpconstraint Customers
EXEC sp_helpconstraint Customers重新启用禁用表的约束（CHECK)
1ALTER TABLE Customers
2CHECK
3CONSTRAINT CN_GeeWu
ALTER TABLE Customers2
CHECK3
CONSTRAINT CN_GeeWu创建规则
1CREATE RULE SalaryRule
2AS @GeeWu = 'GeeWu'
CREATE RULE SalaryRule2
AS @GeeWu = 'GeeWu'查看规则内容
1EXEC sp_helptext SalaryRule
EXEC sp_helptext SalaryRule
应用规则
sp_bindrule <'rule'> , <'object_name'>,[<'futureonly_flag'>]
1EXEC sp_bindrule 'SalaryRule' , 'Employees.Salary'
EXEC sp_bindrule 'SalaryRule' , 'Employees.Salary'取消应用的规则
1EXEC sp_unbindrule 'SalaryRule' , 'Employees.Salary'
EXEC sp_unbindrule 'SalaryRule' , 'Employees.Salary'
消除规则
DROP RULE <'rule'>
创建默认值
1CREATE DEFAULT SalaryDefault
2AS 0
CREATE DEFAULT SalaryDefault2
AS 0应用默认值
1EXEC sp_bindefault 'SalaryDefault','Employees.Salary'
EXEC sp_bindefault 'SalaryDefault','Employees.Salary'取消默认值
1EXEC sp_unbindefault 'Employees.Salary'
EXEC sp_unbindefault 'Employees.Salary'
删除默认值
DROP DEFAULT <默认值>
确定那个表或者数据类型上使用了制定的规则或默认值
EXEC sp_depends <对象名>