Change a Doctrine entity's table name at runtime

controller.php

<?php

class FooController extends Controller {

  function fooAction() {
    $em = $this->getDoctrine()->getEntityManager();

    $cm = $em->getClassMetadata('FooBundle:FooEntity');

    $cm->setTableName('special_table_name');

    $repo = $em->getRepository('FooBundle:FooEntity');

    $entities = $repo->createQueryBuilder('f')
            ->setMaxResults(1)
            ->orderBy('f.id', 'desc')
            ->getQuery()
            ->getResult();

    return new Response('');

  }
}

Great!

Thanks for sharing