Professional Web Applications Themes

rename coulmn using sql statement - Microsoft SQL / MS SQL Server

I don't know why you find the standard T-SQL solution to be unacceptable. You can also to this with DMO by setting the Name property of the Column object. -- Tom --------------------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com/sql "Jeff" <net> wrote in message news:OheJ#phx.gbl... Using sql statement In the table 'customers' just want to rename the column 'name' to 'first_name' I can do it using EXEC sp_rename 'customers.[name]', 'first_name', 'COLUMN' But I want to do it another way. Fish...

  1. #1

    Default Re: rename coulmn using sql statement

    I don't know why you find the standard T-SQL solution to be unacceptable. You can also to this with DMO by setting the Name property of the Column object.

    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "Jeff" <net> wrote in message news:OheJ#phx.gbl...
    Using sql statement

    In the table 'customers' just want to rename the column 'name' to
    'first_name'

    I can do it using

    EXEC sp_rename 'customers.[name]', 'first_name', 'COLUMN'

    But I want to do it another way.

    Fish



    Tom Guest

  2. #2

    Default Re: rename coulmn using sql statement

    What other method do you want to use?
    You could drop and recreate the entire table -- with the new name in place. Of course you will have to save your data....

    --
    Keith, SQL Server MVP

    "Jeff" <net> wrote in message news:OheJ%phx.gbl... 
    Keith Guest

  3. #3

    Default Re: rename coulmn using sql statement

    Then what does this actually mean?

    'EXEC sp_rename' at the beginning of the statement








    "Keith Kratochvil" <com> wrote in
    message news:uHX%phx.gbl...
    What other method do you want to use?
    You could drop and recreate the entire table -- with the new name in place.
    Of course you will have to save your data....

    --
    Keith, SQL Server MVP

    "Jeff" <net> wrote in message
    news:OheJ%phx.gbl... 


    Jeff Guest

Similar Threads

  1. order by and index coulmn
    By Ken in forum Informix
    Replies: 2
    Last Post: November 23rd, 04:37 AM
  2. [PHP] rename()
    By Edward Peloke in forum PHP Development
    Replies: 0
    Last Post: September 11th, 08:44 PM
  3. rename()
    By Edward Peloke in forum PHP Development
    Replies: 0
    Last Post: September 11th, 07:21 PM
  4. Replies: 0
    Last Post: September 10th, 08:48 AM
  5. Wildcards in rename()?
    By Alvaro Puente in forum UNIX Programming
    Replies: 2
    Last Post: July 14th, 10:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139