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-2012 FunctionX, Inc.