Renaming a Table With SQL

To rename a database object, such as a table, use the SQL ALTER statement, as shown in Example: Renaming a Table Using SQL.

Renaming a Table Using SQL

-- rename the my_birthdays table
ALTER TABLE my_birthdays RENAME to birthdays;