The ALTER TABLE statement is used for addition, deletion, modification of columns in an existing table.
Syntax:
ADD Column:
ALTER TABLE table_name
ADD column_name datatype;
Example:
ALTER TABLE PLAYERS
ADD SCORES INT;
DROP Column
ALTER TABLE table_name
DROP column column_name ;
Example:
ALTER TABLE PLAYERS
DROP COLUMN SCORES ;
Learn more : SQL Tutorial , SQL Interview Questions