There are at least three different table classifications supported by the SQL specification. There are two quick ways to rename them.
An SQL development environment, such as a MySQL client and server connection.
There are two ways to rename a table, which differs depending on the type of table. You can alter a table with either:
alter table tableName rename to tableNewName;
or with as instead of to:
alter table tableName rename as tableNewName;
rename table tableName to tableNewName;
or a variation on rename table:
rename table tableName to tableNewName, secondTableName to secondTableNewName;
Temporary tables cannot use rename table. You can of course remove a table with:
drop table tableName;