changing name of a column in a table

[amunim]

could someone help me how to change the name of a column in the table using SQL <br>thanks in advance

 

[MalcolmW]

Standard SQL syntax is<br>select table.field1 AS SomeBetterName<br>from table<br> <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>

 

[shyamal]

Try:<br><br>sp_rename 'tablename.fieldname', 'newfieldname', 'COLUMN'

 

[MikeLacey]

Hmmmm - wish you could do that in Oracle :-(<br><br>you have to copy the whole table to somewhere else, then drop the original one and then recreate the table (remembering to change to col name) and repopulate it from copy.....<br><br>table with ten rows? no prob<br><br>table with ten thousand rows? no prob<br><br>table with ten million rows? big pain in the (*&^% <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[MalcolmW]

Thanks for correcting my posting Shyamal - I must have been brain dead on Aug 4.

 

[amunim]

now replies .. starting to be interesting<br><br><br>No other way more simple than copy - drop - recreate new table - repopulate from copy ?<br><br>

 

[mohmehran]

As Shyamal wrote, you can use sp_rename stored procedure to rename the column name. (Hoping you are using SQL Server as RDBMS)


EXEC sp_rename 'table.[old field name]', '[new field name]', 'COLUMN'