Copy Code Trigger Definition 

                
                CREATE trigger TR_REVENUERECOGNITION_DELETE_BBNCREVENUERECOGNITIONIDMAP on dbo.REVENUERECOGNITION after delete not for replication
                as begin
                    delete from dbo.BBNCREVENUERECOGNITIONIDMAP
                        where REVENUERECOGNITIONID in (select ID from deleted)
                end