check index on field or checking index before deliting in sql explorer oracle

 Right click on connection.

Select Schema browser

Select your schema

Select you table 

Go to Index tab

you will be able to see unique indexes.