2009/12/22 Pau Marc Munoz Torres <paumarc@xxxxxxxxx>
-- 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@xxxxxxxxx
http://filip.rembialkowski.net/
