ALTER

ALERT can be used to modify any table settings or data within the table:

• Add/Drop a column
• Rename a table

Syntax

sql

ALTER TABLE [db.]table
   [ADD COLUMN name type ... 
    | DROP COLUMN name
    | RENAME name
   ]

Examples

Add column

Adds a new column to the table:

sql

ALTER TABLE monitor ADD COLUMN load_15 double;

Definition of column is the same as in CREATE.

We can set the new column’s location. In first position for example:

sql

ALTER TABLE monitor ADD COLUMN load_15 double FIRST;

After an existing column:

sql

ALTER TABLE monitor ADD COLUMN load_15 double AFTER memory;

Remove column

Removes a column from the table:

sql

ALTER TABLE monitor DROP COLUMN load_15;

The removed column can’t be retrieved immediately by all subsequent queries.

Rename table

Renames the table:

sql

ALTER TABLE monitor RENAME monitor_new;

This command only renames the table; it doesn’t modify the data within the table.