DROP COLUMN

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

Syntax

ALTER TABLE [schema_name.]table_name DROP COLUMN column_name

schema_name ::= identifier

table_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

ALTER TABLE
  users DROP COLUMN weight;

Removing a Column with a Quoted Identifier Name

ALTER TABLE
  users DROP COLUMN "Weight in kilograms";

Permissions

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