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