Microsoft Access SQL Keywords: COLUMN

	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;

ALTER TABLE TableName
DROP COLUMN ColumnName