I have a table with 38 columns in it. The order of the columns is very important, for in my C# program I use an enumeration of the column name to address the particular column.
After adding two columns, they were not placed at the end of the table, where I thought they would be. Instead, they were placed before the last existing column, which throws the enumeration off and I don't get the right data.
For example: In the code below, "Notes" is the enumerator to get to the 25th column.
Why didn't it add the two columns at the end of the table?
how do I determine the order of the columns?
or is there a better way of doing this?