• drop index tablename.indexname

    But I suspect there maybe more to your question! Is this index used to support a primary key or unique constraint?

    Mike John