Post reply

Change the name of the column

  • April 29, 2004 at 4:19 am

    #161467

    Hello !!

    Is it possible to change the name of a column by the statement ALTER TABLE in the Query Analyzer ?

    Thanks

    Flavio

  • April 29, 2004 at 6:59 am

    #504662

    You should use sp_rename for this case.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • April 29, 2004 at 7:10 am

    #504666

    Frank, thank you very much!

    Bye bye

    Flavio

  • April 30, 2004 at 2:22 am

    #504776

    Hi Flavio,

    Just in case you forget, please please check that there are no stored proc referencing this column before making the changes. If there is, you have to take this change into account.

    Bye

    Herb

  • April 30, 2004 at 3:06 am

    #504783

    Yes, Herb

    Before to change the name of the column, I cheked (and modified) all the stored procedures referencing this column

    Thank you veru much!

    Bye bye

    Flavio

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply