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

2006-11-09 Thread Richard Huxton
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

[GENERAL] Changing the number and type of columns in a view

2006-11-09 Thread Russell Smith
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.