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.

To rename a table, use the ALTER TABLE command:

   MYDB.SCHEMA(USER)=> ALTER TABLE weather RENAME TO forecast;

Note: This command requires exclusive access to the table before it runs, and waits until it has exclusive access.