TR_RESERVATIONNOTETYPECODE_DELETE_SYSTEMROLEPERMCODETABLEENTRY

create trigger TR_RESERVATIONNOTETYPECODE_DELETE_SYSTEMROLEPERMCODETABLEENTRY on dbo.RESERVATIONNOTETYPECODE after delete not for replication as begin delete from dbo.SYSTEMROLEPERM_CODETABLEENTRY where CODETABLECATALOGID = '7e289b15-877b-4400-a9f5-56c540730bb1' and CODETABLEENTRYID in (select ID from deleted) end