TSQL - How to add multiple columns to a table at once (and how to drop them too)

-- Add

alter table [DATABASE_NAME].[SCHEMA_NAME].[TABLE_NAME]

add

       [FIELD_NAME_1] varchar(4) null

       , [FIELD_NAME_2] tinyint null

       , [FIELD_NAME_3] varchar(3) null

       , [FIELD_NAME_4] tinyint null

;

-- Drop

alter table STRESSTEST.dbo.TransactionStressed

drop column

       [FIELD_NAME_1]

       , [FIELD_NAME_2]

       , [FIELD_NAME_3]

       , [FIELD_NAME_4]

;