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


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


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


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;