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

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.

I'm currently running 8.1 when I say it's not possible.

Thanks

Russell Smith

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