>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)