Columns moving within tables (MSSQL)

1
When we change an attribute of a column.  The code is deployed the column is dropped and moved to the end of the table.  The problem is we are required to a MSSQL dump of all the tables and send them to our client for reporting purposes.  The client uses AWS but does not put data in MSSQL.  I think they use AWS buckets.  Every time a column shifts inside the table this causes the client major issues.   Is there a way to keep the columns from shifting when we are doing the coding?
asked
0 answers