TR_DESIGNATIONLEVEL_DELETE_BBNCDESIGNATIONLEVELIDMAP

                CREATE trigger TR_DESIGNATIONLEVEL_DELETE_BBNCDESIGNATIONLEVELIDMAP on dbo.DESIGNATIONLEVEL after delete not for replication
                as begin
                    delete from dbo.BBNCDESIGNATIONLEVELIDMAP
                        where DESIGNATIONLEVELID in (select ID from deleted)
                end