In SQL Server, table add a column. causing view error -

in sql server, create view using 2 tables. 1 of tables used * in view.

then add column table. causing view error.

must rebuild view solve problem.

if table used lot of views, how identify relevant views , rebuild them?

there number of ways?

thank you!

test environment: sql server 2008

test sql:

 if exists(select * sys.objects name='tbltesta' , type='u') drop table  tbltesta  create table tbltesta(part varchar(10),qty int) insert tbltesta values('a',10) insert tbltesta values('b',20) go  if exists(select * sys.objects name='tbltestb' , type='u')     drop table  tbltestb go  create table tbltestb(part varchar(10),price decimal(9,4)) go  insert tbltestb values('a',1.1) insert tbltestb values('b',2.2) go  if exists(select * sys.objects name='v_test' , type='v')     drop view  v_test go  create view v_test   select a.*,b.price   tbltesta a, tbltestb b    a.part=b.part go 

execute:

select * v_test  go 

result:

part qty price   10  1.1000 b   20  2.2000 

add column

alter table tbltesta add remark nvarchar(200) not null default('test') go 

execute:

select * v_test  go 

result:

part qty price   10  test b   20  test 

you can figure out related views using sql server management studio.

you need select table in ssms , right click it. select view dependencies.

in picture table companycategoryxref (blue arrow). dependent view in case companycategory (red arrow). can see selected item companycategory of object type view (yellow circle).