SQL: Change the name of Existing Table

We can change the name of existing table using alter statement.

Syntax:

alter table table_name rename to New_name;

in above statement,  Alter table and rename to are the keywords.

Example:

alter table authors rename to author_detail;

result:

table altered