How to change the name of a column in a table

[amunim]

I am using SQL 7 and would like only to change the name of the column using SQL commands

 

[foxdev]

You can use either the sp_rename stored procedure or, in the Enterprise Manager, right-clicking the table and choose Design&nbsp;&nbsp;Table; you can change the column name in the resulting grid. <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>

 

[Waynest]

You can use access 2000 as a table designer for sql server, I find it useful.&nbsp;&nbsp;You can do your triggers etc from there too, its pretty neat.