SQL ALTER TABLE Statement

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