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