The RENAME TABLE statement gives an existing table a new name.
Figure. Change the name of the PLAYERS table to TENNIS_PLAYERS.
All other database objects that refer to this table are changed accordingly. Assigned privileges do not disappear, foreign keys remain, and views that use this renamed table keep on working.
Most SQL products support the RENAME TABLE statement, but still not all.