Обсуждение: 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"
thanks
--
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
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"
thanks
--
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
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
--
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
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