Sheena,

In my own framework I keep a data dictionary of tables, fields, and indexes. I also keep a "sequence" number for each field in a table. The code then becomes (highly abbreviated):

SELE Field_name,field_type,field_len,field_dec;
  FROM MyDictionaryFields;
  ORDER BY nSequence;
  WHERE TABLE = m.TheTableIWant;
  INTO ARRAY A_Fields
CREATE TABLE Temp FROM ARRAY A_fields
APPEND FROM (m.TheTableIWant)

This ought to get the main ideas across.

>Hello:
>
>I'm changing the structures of my existing tables in a program
>and was wondering if anyone knew how I could position the
>fields in my database in a particular order Without having to use
>an external product i.e. database toolkit or do I have to drop columns
>add new fields and then add back the columns I dropped for positioning
>purposes?
>
>Any input would be appreciated.
>
>Thanks.