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'
原文地址:https://www.cnblogs.com/wyt007/p/6527127.html