Programs

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. 

Learn to build applications like Swiggy, Quora, IMDB and more

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.

What is SQL?

The Structured Query Language (SQL) is a programming language that allows you to create complex queries. It is the dominant language for maintaining database systems and performing a variety of data handling tasks. SQL was first created in 1970. It's a database language that may be used to create, delete, fetch, and change records, among other things. It's sometimes pronounced as 'sequel'. It may also be used to manage data that is structured and consists of entities (variables) and relationships between them. Executing queries, retrieving data, inserting records, updating records, removing records, building new databases, tables, and views, and performing complicated database operations are just a few of the usual uses.

What are the different types of commands on SQL?

DDL, DML, DCL, and TCL are the 4 different types of commands in SQL. DDL, or Data Definition Language, is a portion of SQL commands that describes the data structure of a database in the early stages of its creation and includes instructions to create, change, and remove data. DML, or Data Manipulation Language, is a programming language that is used to alter data in a database. In other words, these commands help users in retrieving and manipulating data. The Data Control Language, or DCL, is used to manage database data access. TCL or Transaction Control Language is a programming language that is used to manage the modifications produced by DML instructions.

What are other commands used along with the SELECt query in SQL?

Where, order by, group by, and having are some common SQL clauses used in combination with a SELECT query. The WHERE clause in SQL is used to filter needed records based on specified criteria. The ORDER BY statement in SQL is used to arrange data in ascending (ASC) or descending (DESC) order based on the field(s) provided. In SQL, the GROUP BY clause is used to combine entries with comparable data, and it can be used with aggregation methods to provide summarized database results. Also, the HAVING clause is used in conjunction with the GROUP BY clause to filter records. It differs from the WHERE clause in how it can screen pooled records.

Want to share this article?

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 *

Our Popular Software Engineering Courses

Get Free Consultation

Leave a comment

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

×
Let’s do it!
No, thanks.