How To Rename Column Name in SQL Server

The process to rename the column name has been discussed. Using stored procedure, we can easily change the name of column.

Other Video which are useful in this categories (Database)

How To Rename Column Name in SQL Server
How to Change Data Type of Column
How to Create Connection String For SQL Server
What is Relational Data Model and Database Schema ?
What is Data Model in Database ?
Introduction of Database Management System
Best Way to Write Basic SQL Queries
Database Keys and Types of keys
How to Fix SQL Server Error 40 ! Could not open a connection to SQL Server
Keyword Not Supported : Provider || Fix error Keyword not supported in connection string

[iboelevatorworld]

Thank you so much, i tried many time but your small video made my query executed

[Mrcric]

cheetah! First guy to explain it best. Thanks bro!

Only thing i will say is that 'Column' is not necessary you can also do

exec sp_rename 'tablename.columnname', "new column name";

Double quotes are used for columns and values within the table use single quotes.

[RahulKumar-ivtf]

This question is asked me in the interview and I failed to answer.
Thanks for making this video.

[mrb]

thanks sir i have finally chnaged column name

[chitra]

Thank you so much, I was struggling with alter command to rename😁

[hariskhan]

thanks sir this video was very helpful .

[SarojKumar-qkke]

Thanks for this video bro...its really helpfull

[yashjk]

I want to change column name and data like y or n change to yes or no in azure analysis service server

[moqeetbajwayt]

I AM USING SQL SERVER 2017 AND SSMS 18.9.1 BUT ITS NOT WORKING ON THIS

[hetaishinig]

can multiple columns be renamed at a time?

[surabhisunil]

is it possible to have a user defined column name?

[yogeshprem]

Hi Sir,
may i know is there any other method to change column name in sql server other than using stored procedure.

[PramodYadav-ilgk]

sir yaha par change or rename kyu nhi chalta hai plzze bta do ?