Tutorialspoint.dev

SQL | ALTER (RENAME)

Sometimes we may want to rename our table to give it a more relevant name. For this purpose we can use ALTER TABLE to rename the name of table.
*Syntax may vary in different databases.

Syntax(Oracle,MySQL,MariaDB):

ALTER TABLE table_name
RENAME TO new_table_name;

Columns can be also be given new name with the use of ALTER TABLE.
Syntax(Oracle):



ALTER TABLE table_name
RENAME COLUMN old_name TO new_name;

Syntax(MySQL,MariaDB):

ALTER TABLE table_name
CHANGE COLUMN old_name TO new_name;

Sample Table:

Student

ROLL_NO NAME AGE
1 Ram 20
2 Abhi 21
3 Rahul 22
4 Tanu 19

QUERY:

  • Change the name of column NAME to FIRST_NAME in table Student.
ALTER TABLE Student RENAME COLUMN NAME TO FIRST_NAME;

OUTPUT:

ROLL_NO FIRST_NAME AGE
1 Ram 20
2 Abhi 21
3 Rahul 22
4 Tanu 19
  • Change the name of the table Student to Student_Details
ALTER TABLE Student RENAME TO Student_Details;

OUTPUT:

Student_Details

ROLL_NO FIRST_NAME AGE
1 Ram 20
2 Abhi 21
3 Rahul 22
4 Tanu 19

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.



This article is attributed to GeeksforGeeks.org

You Might Also Like

leave a comment

code

0 Comments

load comments

Subscribe to Our Newsletter