Re: create or replace view

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?