Change Column Names

microsoft.public.sqlserver.programming

17 Mar 2006 7:54 PM

Chris

Can someone help with a query to change the column names in a table

Thanks

Chris

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