Re: Changing the number and type of columns in a view

Russell Smith wrote:
> Hi General,
>
> Is there a reason why it is not possible to redefine a view with a
> different number of columns or a different column type?
> It's been possible to change the datatypes of a table, and the column
> numbers for a long time.  What are the restrictions on making this
> possible for views.
>
> I know you can drop an recreate the view, but if the view has dependent
> objects it becomes more difficult.

That's why - the dependent objects might have to change with it.

I suppose it should be possible to add columns to a view without causing
too many problems. Or change a column-definition provided it isn't
referenced anywhere.

--
   Richard Huxton
   Archonet Ltd