Re: Order of columns within a table

In relational database theory, rows and columns have no order for a table when they are stored. In practice, this is not true as you have found out. But one's applications should stick to this theory and not rely on the stored order of things.

Anyway, you can copy the table, drop the original, and copy back if you want to change the order:

   CREATE TABLE temp_table AS SELECT * FROM orig_table;    DROP orig_table;
   CREATE TABLE orig_table AS SELECT * FROM temp_table; You'll also have to recreate indexes and constraints.

HTH,
Brian

JD wrote:
>
> I am using 7.3.4 and would like to be able to change the order of the colums
> (there are about 25) in a table. A front-end program I use queries the
> database and displays the columns in the same order as they are in the
> schema manager. I can change the order of the columns after I run the query,
> but it would be nice to re-arrange them so that I could put the more usefule
> information towards the top. Thanks for any help.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================