Re: [GENERAL] Drop/ Alter index if exist

2009-12-23 Thread Pau Marc Munoz Torres
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 Thread 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 EXISTS name; for rename - there is no simple solution. well, a