Re: create or replace view

On Thursday 14 November 2002 05:22 pm, Bruno Wolff III wrote:
> On Thu, Nov 14, 2002 at 17:00:30 +0000,
>
>   snpe <snpe@snpe.co.yu> wrote:
> > On Thursday 14 November 2002 05:01 pm, Bruno Wolff III wrote:
> > > On Thu, Nov 14, 2002 at 16:49:42 +0000,
> > >
> > >   snpe <snpe@snpe.co.yu> wrote:
> > > > I want that 'create or replace view' work drop-create if view exists
> > > > else only create
> > >
> > > Why do you want this?
> >
> > Why 'create or replace' ?
>
> Why do you want create or replace to do a drop, then a create if the view
> exists but it is being changed in a way that will break any objects that
> refer to the old view?
>
> Are you trying to save typing a few characters or what?
Yes, it is 'create or replace view', not ?