--插入字段和默認值alter table Acc_WayBill add DeclaredValue nvarchar(50)goEXEC sys.sp_addextendedPRoperty @name=N'MS_Description', @value=N'申明價值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Acc_WayBill', @level2type=N'COLUMN',@level2name=N'DeclaredValue'GO

alter table Acc_WayBill add PackingWay intgoEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'包裝方式(0紙箱、1木箱、2其它)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Acc_WayBill', @level2type=N'COLUMN',@level2name=N'PackingWay'GO

--單獨插入字段默認值alter table Acc_WayBillBackBillDetails add DEFAULT 0 for IsReceipt