ALTER TABLE old_table_name RENAME TO new_table_name;
or
RENAME old_table_name to new_table_name;
select tname from tab;
ALTER TABLE old_table_name RENAME TO new_table_name;
RENAME old_table_name to new_table_name;
select tname from tab;