SQL RENAME TABLE

SQL RENAME TABLE syntax is used to change the name of a table. Sometimes, we choose non-meaningful name for the table. So it is required to be changed.

Let\’s see the syntax to rename a table from the database.

ALTER   TABLE  table_name   RENAME  TO  new_table_name;

 

Optionally, you can write following command to rename the table.

RENAME old_table _name  To  new_table_name;

 

Let us take an example of a table named \”STUDENTS\”, now due to some reason we want to change it into table name \”ARTISTS\”.

You should use any one of the following syntax to RENAME the table name:

ALTER TABLE STUDENTS  RENAME TO ARTISTS;

or

RENAME STUDENTS TO ARTISTS;

After that the  table   \”students\”  will be changed into table name \”artists\”