Re ordering a data table

[Joe Keller]

Is there a way through sql or other methods to simlpy change the ORDER of a table without dropping and re creating the table?

[Iouri]

Hi Joe

What order are talking about

1.Records order?
a.You can either write an SQL - select * from YourTable order by YourField
b.Put index on the field, which automatically displays records in order

2.Fields order?
a.what database are working with. In Access you can drag field to any location.
or you can use SQL instead select * - use select Field2, Field3, Field1. Fields will be displayed in SQL statement order

Iouri Boutchkine
iouri@hotsheet.com

[Joe Keller]

It is record order that I am concerned with not field order.

The dilema im having here is this.

When I do a select statement I can get a recordset in the correct order. That is great.
But what I need is the TABLE to be in the correct order. So... I need to do a SELECT INTO the same table. And you cant have the same source and destination tables.

[Iouri]

Put index on the field(s). It will give you the desired order.

Iouri Boutchkine
iouri@hotsheet.com

[Joe Keller]

Thanks for your help Louri.. I figured it out. Works fine now.