ALTER

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table, it is also used to add and drop various constraints on an existing table.

• To add a column in a table, use the following

Syntax

ALTER TABLE table_name ADD column_name datatype;

• To delete a column in a table, use the following

Syntax

ALTER TABLE table_name DROP COLUMN column_name;