rename a table

alter table
   table_name
rename to
   new_table_name;