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 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

Solution 7

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

Posted 31-Aug-15 20:02pm

Member 10584790

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.

Add a Solution

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

How to change column name in sql

4 solutions

Solution 1

Solution 5

Solution 7

Solution 8

Add your solution here

Preview 0

How to change column name in sql

4 solutions

Solution 1

Solution 5

Solution 7

Solution 8

Add your solution here

Preview 0

Existing Members

...or Join us