这个表中一共两列,regionid 列,regiondescription列,改成下面这样还是不行 use df go if exists(select * from information_schema.check_constraints where constraint_name = 'regiondescription_check') alter table region drop constraint regiondescription_check go alter table region with nocheck add constraint regiondescription_check check(regiondescription like '(206)[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]') go insert region(regionid ,regiondescription) values ('10', '(206)111-9999') 报同样的错误
use df
go
if exists(select * from information_schema.check_constraints where constraint_name = 'regiondescription_check')
alter table region drop constraint regiondescription_check
go
alter table region with nocheck add constraint regiondescription_check
check(regiondescription like '(206)[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]')
go
insert region(regionid ,regiondescription) values ('10', '(206)111-9999')
报同样的错误