SQLALTER TABLE Keyword
ALTER TABLE
TheALTER TABLE command adds, deletes, or modifies columns in a table.
TheALTER TABLE command also adds and deletes various constraints in a table.
The following SQL adds an "Email" column to the "Customers" table:
Example
ALTER TABLE Customers
ADD Email varchar(255);
ADD Email varchar(255);
The following SQL deletes the "Email" column from the "Customers" table:
Example
ALTER TABLE Customers
DROP COLUMN Email;
DROP COLUMN Email;
