Re: Drop/ Alter index if exist

thanks

2009/12/22 Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>

>
>
> 2009/12/22 Pau Marc Munoz Torres <paumarc(at)gmail(dot)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(dot)rembialkowski(at)gmail(dot)com
> http://filip.rembialkowski.net/
>

--
Pau Marc Muñoz Torres

Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar

Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)

telèfon: 93 5812807
Email : paumarc(dot)munoz(at)bioinf(dot)uab(dot)cat