Hi

I ran into a problem where I needed to know if an index was created using the Unique clause. However, I could not find any function that would return this info.

Other than routing the Display Status to a text file and searching the results does anyone know how to determine this programmatically?

Ideally it would be good to have a function that returned the index type (ie. Primary, Candidate, Unique).

Thanks
Simon