Change a column name

You can change the name of table columns without changing any of the data. The data remains the same type and size. You must be the owner of the table or have the Alter privilege on tables to change the name of table columns.

To change name of a column, enter:

   MYDB.SCHEMA(USER)=> ALTER TABLE distributors RENAME COLUMN address to 
city;