Rename a column

JENKINSACTIVE · November 23rd, 2004, 10:34 AM

Hi

I need to change a column name in a table , i have used the following but it doesnt work

ALTER TABLE mytablename CHANGE oldcolumnname newcolumnname

please let me know why this doesnt work

JENKINSACTIVE · November 23rd, 2004, 10:46 AM

Its ok i found the command
sp_rename tablename.oldcolname,newcolname,'COLUMN'

bph · November 24th, 2004, 10:03 AM

You could also, in EM, right click on the table, click design table, find column and make the chnage there.

But it's always better to know the sp.

Vadivel · December 16th, 2004, 01:11 AM

sp_rename is the system stored procedure used to rename user created objects like "stored procedure", "trigger", "table" etc., This SP works pretty fine as long as you don't use it to rename a 'Stored Proc", "Trigger" or a "View".

For more information checkout my blog entry @ http://vadivel.thinkingms.com/PermaL...6-b255e22e47c3

MVP ASP/ASP.NET
http://vadivel.thinkingms.com