Alter table t_XXX drop column DATA_ATT_ID -- 删除某一列
Alter table t_XXX add DATA_ATT_ID nvarchar ( 50 ) NOT NULL default '123@123.com'; -- 添加某一列
--给此列加注释
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'来源名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_XXX', @level2type=N'COLUMN',@level2name=N'BarCodeTypeName'
GO