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

expr expr

Syntax

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

Arguments

Argument Description Further 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

Examples

ADD stock column to products table

ALTER TABLE products ADD stock int;

ADD Hobbies column to skillset table

ALTER TABLE skillset ADD Hobbies string;

DROP Hobbies column from skillset table

ALTER TABLE skillset DROP Hobbies;