Renaming columns in SQLServer.

[Daniel Abels]

Hi everyone,

Is there an easy way to rename columns in SQL Server 6.5?

I've been looking in enterprize manager, but I can't save the results.

Surely I don't have to copy the entire contents of the table, delete the
table,
recreate the table with the correct column name(s) and then copy the
contents
back again?!

Daniel Abels
Dunson Pty. Ltd.
dan...@dunson.com.au
d...@alphalink.com.au

[Tim Shay]

Quickest and easiest way would be to drill down to the table
definition in SQL Enterprise Mgr, select the column you want
to change, and save. The only thing to remember - any
applications or stored procedures using the column should
be rebuilt...
T//S <two...@tarheel.net>

Daniel Abels <dan...@dunson.com.au> wrote in article
<01bc869c$d23f1160$0c0a0a0a@daniel>...