The RENAME statement

The RENAME keyword is used to change the name of an existing database object (like table) to a new name.

The RENAME statement has the following basic syntax:

	-- renaming a table in the database
	RENAME TABLE 'current_table_name' to 'new_table_name';