SQL Server - indexkey_property()

[pdV6]

Does anybody know if there is a SQL-7 alternative to the SQL-2000 indexkey_property() metadata function?

Cheers

[pdV6]

Cor! You can hear a pin drop on this thread...

I take it that's a 'no', then?

[IPAddis]

Don't know, never heard of it. What does it do?

[pdV6]

Returns (occasionally) useful stuff about indexes, for example: whether they're ascending or descending (which is what I need to know via a scrpt).

[IPAddis]

pdV6 said:

Returns (occasionally) useful stuff about indexes, for example: whether they're ascending or descending (which is what I need to know via a scrpt).

If you know the index name, can you not examine properties like that by querying the system tables?

Don't know, never tried it.

Ian A.