Purpose

Use the Drop clause to drop a column from an existing table. It is optional.

Syntax

DROP {[COLUMN] column_name}

where:

column_name
specifies an existing column in an existing table.

Notes

  • Drop fails if a SQL view includes the column.

Example A

This example drops the status column. For the operation to succeed, the status column cannot have a constraint defined on it and cannot be used in a SQL view.

ALTER TABLE test DROP COLUMN status