I think SQL Source Control should enforce identical column ordering, that way we can write a statement such as
SELECT * FROM Table1
And know that if our databases are linked and up to date, we will return columns in the same order every time, no matter which database we use.
As it is now, SQL Source Control does not even recognize a column reordering as a change.
Could RedGate add this to the Source Control technology?
P.S. We just got on board recently and the product truly is amazing.