I am using ArcGIS 10.4.1 and Alter Field from Model builder in SDE and it behaves differently in these two cases:
- when altering a field in a feature class or table that consists in increasing the size, for example for text(10) to test(30) the field stays at the same position
- when altering a field in a feature class or table from numeric to text, the field moves at the end of the feature class.
What I did is that I truncate the feature class to empty it, and I altered the field changing the type from numeric to text in ArcCatalog. With ArcCatalog I had the illusion that the position of the field did not change. But after closing and reopening Arcatalog the field shows at the end of the feature class.
Any suggestion in how to change the type of a field by Model builder, Python or .Net and keep the position of the field.