SQL Server2014

Question

请问用sql命令设置默认值约束时，出现“约束'table'的定义中有语法错误”应怎么改？
alter table student
alter constraint df_age default(18)

Answer 1

ALTER TABLE student
ADD CONSTRAINT df_age DEFAULT 18 FOR age;