Alter Table imPlnDtl add
[InvAdjQtyAcctNo] [char] (6) NOT NULL CONSTRAINT [DF_imPlnDtl_InvAdjQtyAcctNo] Default (''),
[InvAdjQtyProfitNo] [char] (3) NOT NULL CONSTRAINT [DF_imPlnDtl_InvAdjQtyProfitNo] Default ('000')
GO
/******************************************/
declare @tbname sysname
declare @fdname sysname
declare @sql1 as varchar(300)
declare @sql2 as varchar(300)
set @tbname='imPlnDtl'
set @fdname='InvAdjQtyAcctNo'
select @sql1='alter table ['+b.name+'] drop constraint ['+d.name+']'
from syscolumns a
join sysobjects b on a.id=b.id and a.name=@fdname and b.name=@tbname
join syscomments c on a.cdefault=c.id
join sysobjects d on c.id=d.id
select @sql2='alter table ['+@tbname+'] drop column ['+@fdname+']'
if ltrim(rtrim(@sql1))<>'' exec(@sql1)
if ltrim(rtrim(@sql2))<>'' exec(@sql2)
GO
declare @tbname sysname
declare @fdname sysname
declare @sql1 as varchar(300)
declare @sql2 as varchar(300)
set @tbname='imPlnDtl'
set @fdname='InvAdjQtyProfitNo'
select @sql1='alter table ['+b.name+'] drop constraint ['+d.name+']'
from syscolumns a
join sysobjects b on a.id=b.id and a.name=@fdname and b.name=@tbname
join syscomments c on a.cdefault=c.id
join sysobjects d on c.id=d.id
select @sql2='alter table ['+@tbname+'] drop column ['+@fdname+']'
if ltrim(rtrim(@sql1))<>'' exec(@sql1)
if ltrim(rtrim(@sql2))<>'' exec(@sql2)
GO
Alter Table imPlnDtl add
[InvAdjQtyAcctNo] [char] (6) NOT NULL CONSTRAINT [DF_imPlnDtl_InvAdjQtyAcctNo] Default (''),
[InvAdjQtyProfitNo] [char] (3) NOT NULL CONSTRAINT [DF_imPlnDtl_InvAdjQtyProfitNo] Default ('000')
GO

