Copy Code Trigger Definition

                
                CREATE trigger TR_TRIBUTE_DELETE_BBNCTRIBUTEIDMAP on dbo.TRIBUTE after delete not for replication
                as begin
                    delete from dbo.BBNCTRIBUTEIDMAP
                        where TRIBUTEID in (select ID from deleted)
                end