TR_DESIGNATION_DELETE_BBNCDESIGNATIONIDMAP

                CREATE trigger TR_DESIGNATION_DELETE_BBNCDESIGNATIONIDMAP on dbo.DESIGNATION after delete not for replication
                as begin
                    delete from dbo.BBNCDESIGNATIONIDMAP
                        where DESIGNATIONID in (select ID from deleted)
                end