>Hi everyone,
>
>I have an assignment to change the order of the fields in a table with ~100 fields. Using Modify Structure for this would be very unsufficient. I have bunch of ideas how to simplify the process (simplest is to write a select statement with the correct order), but I'm wondering, if someone already created a UI for modifing structure?
I'm curious as to why you want to do this.
The only reason I can think of is to make the table more "readable" for maintenance programmers (i.e. logically group fields that "belong" together). If that's the case, and the table doesn't have PKs, relations etc. then your SELECT - SQL idea sounds pretty good.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up