The ALTER TABLE command is a versatile SQL statement that enables the addition, deletion, or modification of columns within a table.
It also facilitates the addition and deletion of various constraints associated with the table.
For instance, the provided SQL snippet illustrates the addition of an “Email” column to the “Customers” table.
| ALTER TABLE Customers ADD Email varchar(255); |
The given SQL removes the “Email” column from the “Customers” table.
| ALTER TABLE Customers DROP COLUMN Email; |