Renaming a table
Renaming a table, like any other change to the structure or meta-information about a table, is achieved via the ALTER command. So, for example, to change the name of table classics to pre1900, use the following command:
ALTER TABLE classics RENAME pre1900;
If you tried that command, you should rename the table back again by entering the following.
ALTER TABLE pre1900 RENAME classics;