SQL修改表字段，加附属属性
时间：2021-07-01 10:21:17
帮助过：32人阅读
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修改表字段，加附属属性
标签：font eve exec logs sql ble pre bsp xtend
