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;