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 the table classics to klassikot, you would use the following command: ALTER TABLE classics RENAME klassikot;
If you tried that command, you should revert the table name by entering the following, so that later examples in this chapter will work as printed:
ALTER TABLE klassikot RENAME classics;