locked
Renaming column name using query RRS feed

  • Question

  • How do we change the Name Like

    I have Table with Name

    Table_1
                 col_1
                 Col_2
                 Col_3

    my query Change My Col_1 name to Col5 permanently not in view only and also i don't want to loose my data which is stored in Col_1

    i have tried couple of queries but its not working like.

    Alter Table TableName change oldColumn  NewColumn Datatype Notnull

    can some one help me out
    • Moved by Ruiz Yi Thursday, September 10, 2009 8:45 AM This post is not a TFS question (From:Team Foundation Server - Work Item Tracking)
    Thursday, September 10, 2009 5:29 AM

Answers