Professional Web Applications Themes

add column between two existing columns with ALTER statement - Microsoft SQL / MS SQL Server

Can I control where a column enters a table using an ALTER TABLE statement? I need to control because of an XML import/export issue. Right now I am doing it manually via Enterprise Mgr. Thx, Wyatt...

  1. #1

    Default add column between two existing columns with ALTER statement

    Can I control where a column enters a table using an ALTER
    TABLE statement? I need to control because of an XML
    import/export issue. Right now I am doing it manually via
    Enterprise Mgr.

    Thx,
    Wyatt
    Wyatt Guest

  2. #2

    Default Re: add column between two existing columns with ALTER statement

    > Can I control where a column enters a table using an ALTER
    > TABLE statement?
    No, you need to drop the table and re-create it. This is what Enterprise
    Manager does if you insert a column into the middle of the stack (watch
    profiler).
    > I need to control because of an XML import/export issue.
    Couldn't you name your columns instead of using SELECT *? What ever would
    you do if you added a column to the table that you did *NOT* want to be in
    the XML stream?

    Or, you could use a view that specifies the columns in the order you want,
    and use SELECT * FROM view

    --


    Aaron Bertrand - MVP Guest

Similar Threads

  1. adding columns to an existing recordset
    By rorajoey in forum Macromedia ColdFusion
    Replies: 2
    Last Post: April 22nd, 05:29 PM
  2. Replies: 4
    Last Post: October 6th, 10:04 PM
  3. Replies: 0
    Last Post: August 27th, 05:57 PM
  4. Replies: 7
    Last Post: July 20th, 11:12 PM
  5. Selecting all columns, but in a different order in SELECT statement
    By Alex in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: July 12th, 07:38 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