How to Rename Column Name in SQL

Introduction

We are surrounded by Data. We used to store information on paper in enormous file organizers. But eventually, we have come to store it online in what we call databases. This is where SQL comes into the picture.  It’s a language that speaks with databases. SQL stands for the structured query language, but it’s usually called SQL or Sequel.

Essentially, it’s a language that helps us communicate with databases that store your data. On the off chance that you need to pull, alter, add data to an information base, you can utilize the language of SQL to do so. 

If you’re about how it works, just think about a database as a warehouse, that’s how SQL works. Information tables act like file organizers and the actual information is like stored documents. Data is stored in this warehouse or database, and coding languages like C, C++, or Java are used to build warehouse databases. SQL is built to retrieve, manipulate, and access the data. Renaming a column name or table name is one of the most used commands on databases.

Let’s get into a deeper understanding of how to use the RENAME command in SQL.

About the RENAME command in SQL

This order is utilized to change the name of a column to another column name. It is likewise used to change the name of a table to another table name. Let us see how to utilize these keywords in various databases. Let us consider the below table to understand all the examples:

Renaming Column Name in SQL

The syntax to rename a column name in MySQL, MariaDB, Oracle, and PostgreSQL is the same.

1. Renaming a column name using the ALTER keyword.

Syntax:

Line 1: ALTER TABLE TableName

Line 2: RENAME COLUMN OldColumnName TO NewColumnName;

  •         For Example: Write a query to rename the column name “SID” to “StudentsID”.

Line 1: ALTER TABLE Students;

Line 2: RENAME COLUMN SID TO StudentsID;

On executing the above query, you will see the following output:

Output:

StudentsID

SName

Marks

1

Harry

70

2

Rick

50

3

Martha

80

4

Gwen

60

5

John

75

 2. Renaming a column name using the CHANGE keyword.

Syntax

Line 1: ALTER TABLE TableName

Line 2: CHANGE COLUMN OldColumnName NewColumnName Data Type;

For Example: Write a query to rename the column name “SID” to “StudentsID”.

Line 1: ALTER TABLE Students;

Line 2: CHANGE COLUMN SID StudentsID INT;

On executing this query, you will see the output the same as the above.

Must Read: SQL Project Ideas

The Rename Column Name in MS SQL Server

The technique to rename a section name in MS SQL Server is distinctive when contrasted with different databases. In MS SQL Server, you should utilize the stored procedure methodology called sp_rename.

Syntax:

Line 1: sp_rename ‘TableName.OldColumnName’, ‘New ColumnName’, ‘COLUMN’;

For Example:

Write a query to rename the column name “SID” to “StudentsID”.

Line 1:  sp_rename ‘Students.SID’, ‘StudentsID’, ‘COLUMN’;

Output:

StudentsID

SName

Marks

1

Harry

70

2

Rick

50

3

Martha

80

4

Gwen

60

5

John

75

Now, that you know how to rename a column name in various databases, let us also understand how renaming a table name works.

Rename a table name

To rename a table name in MySQL, MariaDB, Oracle databases, the RENAME command can used in SQL as:

Syntax:

Line 1: ALTER TABLE OldTableName

Line 2: RENAME TO NewTableName;

For Example:

Line 1: ALTER TABLE Students

Line 2: RENAME TO ListOfStudents;

On executing the below SELECT query, you will get the complete details of the table ListOfStudents.

Query:

Line 1: SELECT * FROM ListOfStudents;

Output:

StudentsID

SName

Marks

1

Harry

70

2

Rick

50

3

Martha

80

4

Gwen

60

5

John

75

Also Read: SQL Interview Questions & Answers

Conclusion

With that, we conclude this article on the renaming of a column name in SQL. You will find these methods much more useful and simpler after more hands-on practice. If you wish to study MySQL, MariaDB, Oracle, and PostgreSQL become more acquainted with this open-source social information base, take a look at upGrad courses that accompany genuine task insight. It will assist you with learning inside and out and help you master the subject.

All in all, learning and getting hands-on practice on all the databases mentioned in this article will add to your experience. Go through the course overview, learning, and job opportunities involved with it—platforms like upGrad offer power-packed courses designed by the highly reputed institutes like IIIT-B in Full Stack Development.

You get to be a part of an extensive network and meet a lot of people working in the same domain. Also, you are mentored by industry experts who resolve your doubts and support you every time. And one of the unique things you get is that at upGrad, you can opt for a No Cost EMI option and go easy on your pockets.

Prepare for a Career of the Future

UPGRAD AND IIIT-BANGALORE'S PG DIPLOMA IN FULL STACK SOFTWARE DEVELOPMENT
Learn More

Leave a comment

Your email address will not be published. Required fields are marked *

×