>>Hi,
>>
>>I can't figure out how to create a descending primary index... I can use Alter Table to create an ascending one, but it doesn't seem to support any ascending/descening clause. I can easily create it using the interface but I also want to do this programmatically so I can re create indexes easily if something goes wrong.
>>
>>TIA,
>>Jonathan Chan
>
>Don't. Descending indices are inneficient. Create an ascending index, and then SET ORDER TO MYINDEX DESCDENDING.
>
>Hilmar.

Are you saying that it is not possible or are you just saying that i really shouldn't? There would need to be some rewriting in quite a few places if my index is turned around, as it is currently descending.