DROP COLUMN

DROP COLUMN can be used to remove columns from a table.

Permissions

The role must have the DDL permission at the database or table level.

Syntax

alter_table_drop_column_statement ::=
    ALTER TABLE [schema_name.]table_name DROP COLUMN column_name
    ;

table_name ::= identifier

schema_name ::= identifier

column_name ::= identifier

Parameters

Parameter

Description

schema_name

The schema name for the table. Defaults to public if not specified.

table_name

The table name to apply the change to.

column_name

The column to remove.

Examples

Removing a column

-- Remove the 'weight' column
ALTER TABLE users DROP COLUMN weight;

Removing a column with a quoted identifier name

ALTER TABLE users DROP COLUMN "Weight in kilograms";