Home All Groups Group Topic Archive Search About
Author
17 Mar 2006 7:54 PM
Chris
Can someone help with a query to change the column names in a table

Thanks

Chris

Author
17 Mar 2006 8:10 PM
Aaron Bertrand [SQL Server MVP]
EXEC sp_rename 'table_name.old_column_name', 'new_column_name', 'COLUMN';




Show quote
"Chris" <Ch***@discussions.microsoft.com> wrote in message
news:4388A639-BA52-481D-9B69-A64420E5B59E@microsoft.com...
> Can someone help with a query to change the column names in a table
>
> Thanks
>
> Chris

AddThis Social Bookmark Button