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";