Unique Index, SQL 2005

Is there a simple way to find properties of an index for a table? Specifically I am looking for the unique property. I currently have code to to do this, however I feel like there must be some easier way.

I am using .net 2005 and SQL 2005 coding in c#. Thanks for any help!



Code Snippet

_conn.Open();
SqlCommand cmd = new SqlCommand("sp_helpindex", _conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@objname", "TABLENAME"));
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(results);


foreach (DataRow row in results.Tables[0].Rows)

{


ArrayList names = new ArrayList();

DataTable dtUnique = new DataTable();

SqlCommand cmd2 = this._conn.CreateCommand();

cmd2.CommandText = String.Format("SELECT INDEXPROPERTY(OBJECT_ID('TABLENAME'), 'INDEXNAME', 'IsUnique') AS isUnique");

dtUnique.Load(cmd2.ExecuteReader());


bool unique = Convert.ToBoolean(dtUnique.Rows[0]["isUnique"]);

if (unique)


names.Add(tableName);

}

_conn.Close();