Re: Change definition of a view

On Thu, 9 Feb 2006 18:11:24 +0100, Andreas Roth wrote
> Hello,
> 
> one question: Is it possible to add or remove a column from a view 
> without drop the view and recreate it?
> 
> If one or more rules depend on a view, it's very hard to extend a 
> view. I use the following procedure to extend a view: - drop depending 
> rules - drop view - recreate view with additional column - recreate 
> all rules
> 
> Any help is welcomed!
> 
> Thanks,
> Andreas Roth

Andreas,

I believe that is exactly what you have to do.

Kind Regards,
Keith