Locating an Index in system files

[lawlerpat]

What system table and field values do I need to search to determine whether an index of a known name exists on a specific table and whether the index was created as Unique or not.
SP_Help is not what i am looking for.

Using sql 2000
I need to be able to do this from VB code

Thanks

 

[ClaireHCM]

you can make usage of sysindexes and sysobjects system tables!

 

[lawlerpat]

Unless I overlooked it, I did not see that iether of these tables informed me as too whether an index was a "unique" type or not.
Do you know if that information is in either of these tables?

Thanks,
Patrick