• You can use like this, with in a transcation.

    if object_id('Table Name') is Not Null

    Begin

    Drop Table Table NameEnd

    Go

    if object_id(column nmae) is Not Null

    Begin

    alter table tablename

    alter column columnname

    Go

    in case of conversion... if we need to updated the column with empty or null values and then you can proceed further..