Re: "if exists" in clause

[Peter Brawley]

> this doesn't permit me to test if the index exists
> before executing the code to drop it

As Jon says, you can query information_schema for that info.

Or more simply, execute the drop index cmd unconditionally and ignore an "index does not exist" error if it occurs.