How I can modify a name of collumn in SQL Server

[scubaman]

Hello,

I´m create a collumn in SQL usin alter table add and a name of collumn

Now I want modify a name that collun using a command SQL

For example collun fname into a table test
How i can change a fname to f1name using language sql

thanks a lot

Luciano Marques

 

[foxdev]

Use the built-in stored procedure SP_RENAME. Robert Bradley

http://www.foxdev.com/

Do you have too much money? Visit

http://www.agrainofhope.org