You can always recreate the dependent views in the same process, since you
won't lose any data. If there are also linked tables you could use COPY
before deleting and recreating, it's fairly fast.
But..does the structure of your data really need to change? Just guessing,
but it just sounds a little like adjusting the schema to suit an
application, not the data.
2010/10/20 Ravi Katkar <Ravi(dot)Katkar(at)infor(dot)com>
> That's true . it wont work if we add remove the columns.
> I wanted to add column to view and change the data type to existing column
>
>