ALTER TABLE statement
Add, Rename or Drop columns from an existing table.
BNF diagrams
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;