I have a lookup table (for pull-down menu values). The table has a primary key - clustered index on a field desired to sort the default order of the list (without having to use 'order by'). The actual data field is also a unique index, and has a foreign key in the related table.

The trouble is that the table does not get default-ordered by the primary key - clustered index. It is ordered by the data field unique index. I have experimented with test tables, and it does not seem to matter what order the indexes are created in, and I have not been able to do it in a fashion to get the default order by the sorting field.

I have been under the evident delusion that the primary key, clustered index (especially if it is the first field in the table) is used by SQL as the default ordering mechanism.

I have tried to find documentation on default ordering, but have been unsuccessful. Can anyone shed some light on this?

All help is appreciated.