• select * from sys.indexes

    where object_id = (select object_id from sys.objects where name = 'TableName')

    using this query u can check the index that is exist on your table.

    Regards,

    Arjun