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