create or alter procedure proc1
AS
begin
  merge into table1 t
  using (select id from table2) c on c.id = t.id
  when matched then
    delete;
end

==== Error ==== : Procedure PROC1: Missing: UPDATE (DELETE)
                  Script:  Line:5 Pos:12