SQL 添字段，修改辽段属性，或备注

alter table alu_kingdee_sales_receipt_detail ADD kingdee_qty [DECIMAL]
alter table alu_kingdee_sales_receipt_detail ALTER COLUMN kingdee_qty DECIMAL(18,2);
ALTER TABLE alu_kingdee_sales_receipt_detail DROP CONSTRAINT DF__alu_kingd__kingd__55B29C15

 

 

alter table alu_kingdee_sales_receipt_detail ADD selttlecur [varchar];
alter table alu_kingdee_sales_receipt_detail ALTER COLUMN selttlecur varchar(100);
EXEC FA_nTier.sys.sp_updateextendedproperty 'MS_Description', N'结算币别', 'schema', N'dbo', 'table', N'alu_kingdee_sales_receipt_detail', 'column', N'selttlecur' 

alter table alu_kingdee_sales_receipt_detail ADD selttlecur_type [varchar];
alter table alu_kingdee_sales_receipt_detail ALTER COLUMN selttlecur_type varchar(100);
EXEC FA_nTier.sys.sp_updateextendedproperty 'MS_Description', N'结算方式1', 'schema', N'dbo', 'table', N'alu_kingdee_sales_receipt_detail', 'column', N'selttlecur_type'