How do you check if a certain index exists in a table?

You can do it using a straight forward select like this:

SELECT * 
FROM sys.indexes 
WHERE name="YourIndexName" AND object_id = OBJECT_ID('Schema.YourTableName')