if we use

DROP INDEX xxx

What could the index have which would be considered dependent?

I.e. if we did

DROP INDEX xxxx CASCADE

What additional objects might be dropped? Will it for example drop the table it was the index on? If not what could it drop?

We are trying to decide if we should be using CASCADE or not.