Declare @Id Int                               
Select @Id = Id From sysobjects Where Name = 'TblDrugUse'
if  Exists(SELECT * FROM syscolumns WHERE id = @Id  and Name = 'Use_Name')
Alter Table TblDrugUse Alter Column Use_Name nvarchar(150)