SQL Statements and Extensions for the Salesforce Driver : Alter Table : Altering a Local Table : Drop Clause: Columns

Drop Clause: Columns
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
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

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.