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