SQL SERVER||Two ways to ADD/DROP New Column in existing table
How to add new column and drop column for already existing table in SQL?
SQL QUERY
Object Explorer
ALTER TABLE [EMP_DATA]
ADD gender CHAR(1)
ALTER TABLE [EMP_DATA]
DROP COLUMN gender