4
Every time I make one ALTER TABLE
and add a column, this field goes to the end.
In design mode, using the Sql Management graphical tool, there is the Insert Column option at any position, but it turns out I can’t save.
I have permission from the bank administrator. How do I, if there is how, include in an existing table, including with data, put this new field in the position I want?
Is there an error to save? You know this will recreate the whole table and do other manipulations in the base?
– Maniero
What error does it give? There might be a Management Studio configuration that would be blocking this (the error would indicate which).
– bfavaretto
Actually it is not an error, just a message that it is not possible to make the change, only if I drop the table and etc. Now I don’t understand the downvote. The question is straightforward and only one answer, I would like to understand these guys here within the forum.
– pnet