Re: [GENERAL] Drop/ Alter index if exist

thanks 2009/12/22 Filip Rembiałkowski > > > 2009/12/22 Pau Marc Munoz Torres > > 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

Re: [GENERAL] Drop/ Alter index if exist

2009/12/22 Pau Marc Munoz Torres > 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, a

[GENERAL] 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 Auto