2009/12/22 Pau Marc Munoz Torres <paumarc(at)gmail(dot)com>
> Hi every body
>
>
> there is some way to delete or rename an index only if this index exists?
>
> something like
>
> "alter index index rename to pepe if exists"
>
>
for drop - yes:
DROP INDEX IF EXISTS name;
for rename - there is no simple solution. well, actually there are solutions
but they are more complicated than the problem.
(think of user defined functions)
--
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/