SQL Keywords: ALTER

The ALTER keyword is used to modify the structure of a table. It can be used to add a new column to an existing table. The formula to use would be:

ALTER TABLE TableName
ADD COLUMN ColumnName DataType

Here is an example:

USE Exercise;
GO

ALTER TABLE Employees ADD EmailAddress nvarchar(60);
GO