I'm used to doing a database design before I start collecting data. If I have the
types wrong, it's because I did a poor job on the database design, and I need to
go back to start in the design process.
File geodatabase, especially through the FGDB API, is just about as mature as
you'd expect it to be for its age. Comparing it to 20 year old databases (most
of which still don't permit you to change type) isn't fair to either.
The FGDB API was released to allow read and write access to geodatabases
outside of ArcGIS. It certainly wasn't meant to become the basis of the next
SQL-Developer app. I wasn't part of the design or implementation of the API,
so I'm not sure why an Alter Field even exists (I'd only expect it to work for
changes to the formatting of fixed-width types). If you're expecting a lot of
new development on the API, to support functionality not related to spatial
data translators (fmtX-to-fgdb or fgdb-to-fmtX), then I'm sorry, but you're
probably going to be disappointed.
- V