Alter Table

  • Does anyone know if there is a command used with Alter Table to add a new column in the middle of a table rather than the end or last column?

  • As of now there is no direct command is available for this, Its In the wish list for future releases

    You can easily do it through Management Studio

  • Moving the field in Enterprise Manager is easy, however I am trying to avoid EM from re-creating the index once the table is saved.

  • Makes no difference where the column is physically in the table.

    Table can be Col1, Col2, Col3. You can retrieve them in any order you need/want/like.

    EM won't "re-create" an index unless you tell it to.

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

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