Re: Change Column name with ALTER statement

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/05/05 

Date: Sat, 5 Feb 2005 15:06:48 -0500

Check out sp_rename in BooksOnLine 

-- 
Andrew J. Kelly  SQL MVP
"Christian Perthen" <abracadabara@dontreplytothisaddress.com> wrote in 
message news:ew3DT27CFHA.3728@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> Quick question.
> How do I change a column name with the ALTER TABLE statement without 
> losing
> the data?
>
> Thanks
> Christian
>
>

Relevant Pages

  • Re: How do I format data in the SQL statement
    ... Andrew J. Kelly SQL MVP ... "Jim Warren" wrote in message ... >> BooksOnLine for more details. ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Check if a table has a specific column
    ... Taka a look at the Information schema views in BooksOnLine. ... Andrew J. Kelly SQL MVP ... "Agoston Bejo" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: Server Roles Process administrators
    ... BooksOnLine is probably the best reference. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Weeks
    ... Check out DATEDIFF in BooksOnLine. ... Andrew J. Kelly SQL MVP "David" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Negative results
    ... Andrew J. Kelly wrote: ... Sorry thanks for pointing that out Kevin. ... Andrew J. Kelly SQL MVP ... Your best option to begin with is to look at the virtual file stats to seehow ...
    (microsoft.public.sqlserver.server)