TR_TAGCODE_DELETE_SYSTEMROLEPERMCODETABLEENTRY

create trigger TR_TAGCODE_DELETE_SYSTEMROLEPERMCODETABLEENTRY on dbo.TAGCODE after delete not for replication as begin delete from dbo.SYSTEMROLEPERM_CODETABLEENTRY where CODETABLECATALOGID = '4a4af59a-db28-416a-8b01-8af33290958b' and CODETABLEENTRYID in (select ID from deleted) end