I have some data dictionary software and some query maker software which both produce a list (either printed or online) of available fields for the clients to use. The software reads all my free tables and shows the column names in order. Well, some of the table have 100+ column and the columns are not in alphabetical order by name or even grouped together logically. As we add new column of course they get added to the end. The clients have not complained but I damn sure can not easily find a column when looking for it.

Is there some utility that will put columns in sorted order? By the way, when I am browsing a table and I drag and drop a column to a new position, is that permanent for everyone? I do not understand column placement in a table.

Thanks

Brenda