Re: Drop/ Alter index if exist

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