Thread: Allow column type to change without worrying about view dependencies

Good morning,

When there are lots of views and complicated dependencies, it is not 
easy to alter column from varchar(a) to varchar(b).

Is it possible when defining a view, adding cascade or some other key 
word(s) to allow column type change?

When column1 is changed, all related views' column type is changed as well.

Thanks,
---
Lu Ying

ulka salvi wrote:
>>
>> u can try this
>> SELECT a,b,c,CAST(d AS float)
>   AS N 'd',e,f,g INTO dbo.newtable
> 
> Ulka

Did not follow.


Example,
create view v_test as select * from test1;
create table test(col1 varchar(12));

I'd like to:
alter table test alter column col1 type varchar(128);

Tried your suggested:
create or replace view v_test as select CAST( col1 as varchar(128)) from 
test;

Got:
cannot change data type of view column "col1"

-- 
Lu Ying