2009/12/22 Pau Marc Munoz Torres <[email protected]> > 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:[email protected] http://filip.rembialkowski.net/
