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

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