Thread: Change definition of a view

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

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