The ALTER statement is used to change the name of the attribute in the existing table.

The general syntax is

ALTER TABLE table_name CHANGE old_attribute_name new_attribute_name

or

ALTER TABLE table_name RENAME old_attribute_name TO new_attribute_name

If a dimension table is created without keys, the user can also use ALTER statement to set the key in the table.

The general syntax is

ALTER TABLE table_name KEY(attribute1, attribute2, ...)

Case Example:

If the ABC company staff want to rename "state" attribute to "Home_State" in the Customer table, he can do this with following commands:

ALTER TABLE Customer CHANGE state Home_state

or

ALTER TABLE Customer RENAME state TO Home_state

He will get the revised Customer table that looks like below: