ALTER ADD COLUMNS¶
Function¶
This command is used to add columns to an existing table.
Syntax¶
ALTER TABLE tableIdentifier ADD COLUMNS(colAndType (,colAndType)*)
Parameter Description¶
Parameter | Description |
|---|---|
tableIdentifier | Table name. |
colAndType | Name of a comma-separated column with data types. A column name consists of letters, digits, and underscores (_). |
Examples¶
alter table h0_1 add columns(ext0 string);
System Response¶
The columns are added to the table. You can run the DESCRIBE command to display the columns.