2009/12/22 Pau Marc Munoz Torres <paum...@gmail.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.rembialkow...@gmail.com
http://filip.rembialkowski.net/

Reply via email to