Rename a table
You can change the name of a table 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 a table.
MYDB.SCHEMA(USER)=> ALTER TABLE weather RENAME TO forecast;