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:

ALTER TABLE Employees ADD COLUMN EmailAddress Text(100);

 

 
 
     
 

Home Copyright © 2005-2011 FunctionX, Inc.