>There is, AFAIK, no way to programmatically change a field's order in the field list. You have to use the designer.
Well, you can use ALTER TABLE a whole bunch of times to reorder. You can certainly say there is no "reasonable" way to do it programmatically...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.