SQL Server - indexkey_property()

SQL Server - indexkey_property()

Author
Discussion

pdV6

Original Poster:

16,442 posts

260 months

Thursday 17th July 2003
quotequote all
Does anybody know if there is a SQL-7 alternative to the SQL-2000 indexkey_property() metadata function?

Cheers

pdV6

Original Poster:

16,442 posts

260 months

Friday 18th July 2003
quotequote all
Cor! You can hear a pin drop on this thread...

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

IPAddis

2,471 posts

283 months

Friday 18th July 2003
quotequote all
Don't know, never heard of it. What does it do?

pdV6

Original Poster:

16,442 posts

260 months

Friday 18th July 2003
quotequote all
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

2,471 posts

283 months

Tuesday 22nd July 2003
quotequote all
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.