Skip to main content Link Menu Expand (external link) Document Search Copy Copied

ALTER TABLE statement

Add, Rename or Drop columns from an existing table.

BNF diagrams

expr

Add column

expr

Drop column

expr

Column definition

expr

Syntax

ALTER table_name [
  ADD {identifier data_type [constraint]} |
  DROP_COLUMN {identifier}
  ];

Arguments

Argument Description Additional information
table_name Name of existing table to alter CREATE TABLE statement
identifier Column identifier or name  
data_type Column data type SQL data types
constraint Optional data type constraint SQL data types

–>