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/

thanks

2009/12/22 Filip Rembiałkowski <plk.zuber@gmail.com>

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/

--
Pau Marc Muñoz Torres

Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar

Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)

telèfon: 93 5812807
Email : paumarc.munoz@bioinf.uab.cat