Deletes a Column.

The main features of ALTER TABLE DROP COLUMN statement are:

  • ALTER TABLE DROP COLUMN is an online and offline operation.
  • ALTER TABLE DROP COLUMN is an offline operation for instances where:
    • Table is in PUB schema.
    • Database is enabled for OpenEdge Replication.
  • ALTER TABLE DROP COLUMN is an online operation for tables defined in non-PUB schema

Impact

When ALTER TABLE DROP COLUMN is performed, the following are impacted:

  • OpenEdge Management — OpenEdge Management does not display table definitions for non-PUB schema except for tables that are Change Data Capture (CDC) enabled. When CDC operations are performed in concurrent transaction with ALTER TABLE DROP COLUMN, OpenEdge Management may return an error because of lock conflict.

    Even without lock conflicts, if you change a column name between the time OpenEdge Management reads the definition and uses the definition via ABL, creating the required CDC policy fails with Column not found error.

  • Progress Developer Studio for OpenEdge — Progress Developer Studio for OpenEdge can fetch table and column definitions, and display them to perform database operations.

    When you perform online ALTER TABLE DROP COLUMN, in concurrent transaction, and when Progress Developer Studio for OpenEdge fetch the data using old column name, then it might return Column not found error.

  • Database utilities — When you perform online ALTER TABLE DROP COLUMN in concurrent operation with database utilities or index utilities (IDXcheck,IDXfix), they might result in lock conflict.