2009/12/22 Pau Marc Munoz Torres <paum...@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.rembialkow...@gmail.com http://filip.rembialkowski.net/