How to alter the Column of Table in SQL

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Dear Developer,

How to alter the Name of Column in Sql Table.
I want to rename the column of the table.
I use the below quary but its not work.

SQL

"Alter table table_name change old_column_name  new_column_name type size"

Its greatful for me if anybody give me correct Query in Sql Database.

Regards,
Ravi Sharma

Posted 12-Sep-11 1:09am

Ravi Sharma 2

Updated 12-Sep-11 1:12am

Toniyo Jackson

v2

Add a Solution

Comments

P.Salini 12-Sep-11 7:15am

In sqlserver You can directly rename the column by right clicking on it and then select rename.

why you want to do it using query.

Toniyo Jackson 12-Sep-11 7:17am

The syntax you are using is correct. Post you sql query

5 solutions

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)

Uday P.Singh · Answer 1 · 2011-09-12T01:13:00

Solution 1

Run this script:

SQL

EXEC sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'

hope it helps :)

Posted 12-Sep-11 1:13am

Uday P.Singh

v2

Prerak Patel · Answer 2 · 2011-09-12T01:13:00

Solution 2

http://msdn.microsoft.com/en-us/library/ms188351.aspx[^]

Posted 12-Sep-11 1:13am

Prerak Patel

Abhinav S · Answer 3 · 2011-09-12T01:14:00

Solution 3

Use sp_rename.
Read more about this here[^] or here[^].

Posted 12-Sep-11 1:14am

Abhinav S

P.Salini · Answer 4 · 2011-09-12T01:20:00

Solution 4

Any way this will help you.

Sqlserver has built in Stored Procedure sp_rename to change the column names of the Tables

EXEC sp_rename
@objname = '< Table Name.Old Column Name >',
@newname = '<new column name>',
@objtype = 'COLUMN'

Posted 12-Sep-11 1:20am

P.Salini

Updated 12-Sep-11 1:22am

v2

AditSheth · Answer 5 · 2011-09-12T01:27:00

for example
my Table Name : table_name
Old Column Name : "OldColumn"
New Column Name : "NewColumn"

SQL

EXECUTE sp_rename N'dbo.table_name.OldColumn', N'Tmp_NewColumn', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.table_name.Tmp_NewColumn', N'NewColumn', 'COLUMN' 
GO

This code change your column name and remain column values as it is.