ALTER ADD COLUMNS

Updated on 2022-11-18 GMT+08:00

View PDF

This command is used to add columns to an existing table.

ALTER TABLE tableIdentifier ADD COLUMNS(colAndType (,colAndType)*)

**Table 1** Parameters
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.

Parent topic: DDL

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel