Table of Contents

SQL - ALTER - ALTER TABLE

Add a new column to a table

ALTER TABLE Students
ADD email VARCHAR (255);

Modify the datatype of an existing column

ALTER TABLE Students
ALTER COLUMN email VARCHAR (512);

Remove an existing column from a table

ALTER TABLE Students
DROP COLUMN email;