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

2009-05-26 Thread Emi Lu
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 su

[SQL] Allow column type to change without worrying about view dependencies

2009-05-22 Thread Emi Lu
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' colum