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.

I need to be able to do this from VB code

Thanks

 

[wbg34]

Please post this in in a database or sql Forum.

 

[lawlerpat]

Oops, sorry.

Wrong Forum.
Its now in sql server programming