SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t (id int primary key, v varchar(30), v2 varchar(30))
insert t values (1, 'hello', 'bye'), (2, null, null)
2 rows affected

create view dbo.v
with schemabinding as
select id, v
from dbo.t
create unique clustered index ix on v(id);
select * from t;
select * from v with (noexpand)


id
v
v2


1
hello
bye

2
null
null




id
v


1
hello

2
null


merge t
using (values(1)) s(id)
on s.id = t.id
when matched then
  update set
  v2 = 'bye2'
when not matched by source then delete;

select * from t;
select * from v with (noexpand);

alter index ix on v disable;
alter index ix on v rebuild;

select * from t;
select * from v with (noexpand);


id
v
v2


1
hello
bye2




id
v


1
hello

2
null




id
v
v2


1
hello
bye2




id
v


1
hello

id	v	v2
1	hello	bye
2	null	null

id	v
1	hello
2	null

id	v
1	hello
2	null