首页 > 代码库 > SQL修改表字段,加附属属性

SQL修改表字段,加附属属性

GO
ALTER TABLE [dbo].[t_Enroll] ADD IsNeedForm INT NULL DEFAULT 0
Go
EXEC sys.[sp_addextendedproperty] @name = MS_Description,@value = 是否填写表单,@level0type = SCHEMA,@level0name = dbo,@level1type = TABLE,@level1name = t_Enroll,@level2type = COLUMN,@level2name = IsNeedForm

 

SQL修改表字段,加附属属性