use tempdb;
set ansi_nulls, quoted_identifier, xact_abort on;
go

create table dbo.t1 (id int primary key);
create table dbo.t2 (id int primary key, t1_id int references dbo.t1(id));
create table dbo.t3 (id int primary key, t1_id int references dbo.t1(id));
go

create view dbo.vt
as
select id as t1_id, null as child_id, 1 as [type] from dbo.t1
union all
select t1_id, id, 2 from dbo.t2
union all
select t1_id, id, 3 from dbo.t3;
go

create trigger dbo.tr_vt
on dbo.vt
instead of delete
as
begin
 set nocount on;

 delete t3
 from
  dbo.t3 t3 join
  deleted d on d.child_id = t3.id and d.[type] = 3;

 delete t2
 from
  dbo.t2 t2 join
  deleted d on d.child_id = t2.id and d.[type] = 2;

 delete t1
 from
  dbo.t1 t1 join
  deleted d on d.t1_id = t1.id and d.[type] = 1;
end;
go

insert into dbo.t1 values (1), (2);
insert into dbo.t2 values (20, 1), (200, 2);
insert into dbo.t3 values (30, 1), (300, 2);

select 't1', * from dbo.t1;
select 't2', * from dbo.t2;
select 't3', * from dbo.t3;

declare @d table (t1_id int, child_id int, [type] int);
declare @t1_id int = 1;

delete dbo.vt with (updlock)
output
 deleted.t1_id, deleted.child_id, deleted.[type] into @d (t1_id, child_id, [type])
where
 t1_id = @t1_id;

select 'deleted child', * from @d where child_id is not null;

select 't1', * from dbo.t1;
select 't2', * from dbo.t2;
select 't3', * from dbo.t3;
go

drop view dbo.vt;
drop table dbo.t2, dbo.t3;
drop table dbo.t1;
go