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