Allow column to be added in specific position (similar to MySQL FIRST | AFTER col_name notation)
Would it be possible to add the functionality to add a column in a specific position - similar to the MySQL functionality?
Writing Schema update scripts & dev to production migration scripts, would be MUCH easier if we didn't have to re-create tables every time we need to re-arrange columns).
I realise the order of the columns is mostly irrelevant as anything important should be indexed, and that adding a new column would probably result in an expensive re-write of all data pages - but SSMS does this anway when using the GUI, so why not do this logic internally with the simple syntax?
In complex applications, having columns grouped together in logical chunks is very important and aides documentation, and its always nice to have your primary key columns together at the top of the table.
ADD COLUMN newCol AFTER existingCol
ADD COLUMN newCol FIRST