Re: How to drop a temporary view?

On Fri, 20 Apr 2012 17:36:59 +0200
Vincenzo Romano <vincenzo.romano@notorand.it> wrote:

> Hi all.
> I'd like use a temporary view "to hide" a non-temp one  for some
> queries. Later I'd need to drop that view in order to "revert to
> normal operations". As there is no "DROP TEMPORARY VIEW ..." I'd be
> forced to "CREATE OR REPLACE TEMPORARY VIEW ..." in order to
> "overwrite" the temporary one with the same code as the non-temporary.
> All this sounds quite complex to me. Is there a way to drop temporary
> stuff before closing the session?
> TIA.

DROP VIEW <view>

It will destroy the view, temporary or not...

Regards

Rodrigo

>
> --
> Vincenzo Romano - NotOrAnd.IT
> Information Technologies
> NON QVIETIS MARIBVS NAVTA PERITVS
>