Thread: Drop/ Alter index if exist

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"

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/