Home

SQL Keywords: COLUMN

 

Adding a New Column

The COLUMN keyword is used to identify a field of a table. The COLUMN keyword 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

Removing an Existing Column

The COLUMN keyword can be used when removing a column from a table in SQL. The formula to use would be:

ALTER TABLE TableName DROP COLUMN ColumnName;

or

ALTER TABLE TableName
DROP COLUMN ColumnName

Home Copyright © 2005-2011 FunctionX, Inc