Javatpoint Logo

91-9990449935

 0120-4256464

Javatpoint Logo

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.

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

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

Table1: students

NameAgeCity
Amrita gill25Amritsar
Amrender sirohi22Ghaziabad
Divya khosla20Delhi

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

Or

Next TopicSQL TRUNCATE TABLE




Share this page

facebook twitter google plus pinterest tumbler

Latest 4 Tutorials