Home

SQL Keywords: ALTER

 

Description

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
             

Home Copyright © 2005-2010 FunctionX, Inc.