====== SQL - ALTER - ALTER TABLE ======

===== Add a new column to a table =====

<code sql>
ALTER TABLE Students
ADD email varchar (255);
</code>

----

===== Modify the datatype of an existing column =====

<code sql>
ALTER TABLE Students
ALTER COLUMN email varchar (512);
</code>

----

===== Remove an existing column from a table =====

<code sql>
ALTER TABLE Students
DROP COLUMN email;
</code>