SQL ALTER TABLE Statement

ALTER Statement

To add a column in a table:

ALTER TABLE table_name
ADD column_name datatype;

To delete a column in a table:

ALTER TABLE table_name
DROP COLUMN column_name;

To change the data type of a column in a table:

ALTER TABLE table_name
MODIFY COLUMN column_name datatype;

To add default value for a column in a table:

ALTER TABLE table_name
ALTER column_name SET DEFAULT value;

To remove default value of a column in a table:

ALTER TABLE table_name
ALTER column_name DROP DEFAULT;