How to change column name in sql

Question

1.50/5 (4 votes)

See more:

SQL-Server-2008

hi all,

i am trying to change column name in sql2008 from StudentId to SID .
i am using this query :

SQL

alter table Student
rename column StudentId to SID

By using this not altered the table column .
so that please any one help to me.
thanks in advance

regarding ,
naresh

Posted 1-May-12 17:07pm

Unareshraju

Updated 30-Jul-19 20:36pm

walterhevedeich

v3

Add a Solution

Comments

walterhevedeich 1-May-12 23:42pm

Your syntax is for Oracle, and will not work on SQL Server. I suggest you take a look at the answer below.

satrio_budidharmawan 2-May-12 0:08am

The question should be like this : "How to change column name in SQL Server with SQL Query".
Because SQL alone, stand for every Database engine

4 solutions

Solution 8

Query: - exec sp_rename 'new_tblencounter.encounter','encounter_dates','COLUMN' ;

It's Works.

Posted 30-Jul-19 20:37pm

Subodh Gaur

Updated 30-Jul-19 20:49pm

v2

Comments

Richard Deeming 31-Jul-19 14:38pm

Adds nothing to the accepted solution from 2012.

If you want to support that solution, either up-vote it, or add a comment to it. Don't repost it as a new solution.

Solution 7

exces sp_rename 'Persons.city','c_name', column

Posted 31-Aug-15 20:02pm

Member 10584790

Solution 5

select studentid as sid,sname,... into #temp from student
u just select all the columns and what ever column name u want to rename just give a name beside that column and import into another table .

Posted 28-Nov-14 23:36pm

Member 11267858

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

VJ Reddy · Accepted Answer · 2012-05-01T17:37:00

Solution 1

The column can be renamed using

SQL

SP_RENAME 'Student.StudentId', 'SID ', 'COLUMN'

as explained here
SQL SERVER – How to Rename a Column Name or Table Name[^]

Posted 1-May-12 17:37pm

VJ Reddy

Comments

walterhevedeich 1-May-12 23:42pm

My 5!

VJ Reddy 2-May-12 0:11am

Thank you, walterhevedeich.

Unareshraju 1-May-12 23:53pm

thank u somuch reddy
by using this i solved my problem
"SP_RENAME 'Student.StudentID','SID'
GO"

VJ Reddy 2-May-12 0:11am

You're welcome and thank you for accepting the solution.

Shahin Khorshidnia 2-May-12 9:04am

+5

VJ Reddy 2-May-12 9:38am

Thank you, Shahin.

Arjun Menon U.K 18-Oct-12 0:00am

SP_RENAME 'Student.StudentId', 'SID ', 'COLUMN'

IS there any other way than the query above using any DML statements.. IT will be of great help,Thanks in adv

Member 10018938 22-Jun-14 5:38am

change column na,e in use simple query in sql server 2008 r2