DELIMITER //
    CREATE TRIGGER del_student
    AFTER DELETE ON Table_B
    FOR EACH ROW
    BEGIN
        DELETE Table_B
        FROM Table_A, Table_B
        WHERE Table_A.ID = Table_B.ID;
    END//
DELIMITER ;