Alter table Part_Maker_Stock_Adjust_Batch_Detail drop column pre_adjust_qty --删除某一列
Alter table Part_Maker_Stock_Adjust_Batch_Detail add pre_adjust_qty int not null default 0--添加某一列
给此列加注释
EXECUTE
sp_addextendedproperty
N'MS_Description', '初盘数量', N'user', N'dbo', N'table', N'Part_Maker_Stock_Adjust_Batch_Detail', N'column', N'pre_adjust_qty'
Alter table Part_Maker_Stock_Adjust_Batch_Detail add pre_adjust_qty int not null default 0--添加某一列
给此列加注释
EXECUTE
sp_addextendedproperty
N'MS_Description', '初盘数量', N'user', N'dbo', N'table', N'Part_Maker_Stock_Adjust_Batch_Detail', N'column', N'pre_adjust_qty'