mutley1
MIS
- Jul 24, 2003
- 909
- 0
- 0
Hi guys,
I've written something in SQL 2000 to retrieve all the user indexes including table, index name, fields it is made up od and the position in the index. This has all come from sysobjects, sysindexes and syskeys. I can get everything from that, but cant find any field, indicator or anything that refers to if the field is ASC or DESC sort withn the index.
Table Index Field Pos in IDX ASC/DESC
Mytbl IDX1 Forename 1 ASC
Mytbl IDX1 Surname 2 DESC
Rubbish example I know, but can anyone point me in the right direction of finding if the field is asc or desc within the index.
Cheers,
M.
I've written something in SQL 2000 to retrieve all the user indexes including table, index name, fields it is made up od and the position in the index. This has all come from sysobjects, sysindexes and syskeys. I can get everything from that, but cant find any field, indicator or anything that refers to if the field is ASC or DESC sort withn the index.
Table Index Field Pos in IDX ASC/DESC
Mytbl IDX1 Forename 1 ASC
Mytbl IDX1 Surname 2 DESC
Rubbish example I know, but can anyone point me in the right direction of finding if the field is asc or desc within the index.
Cheers,
M.
