Symfony2 - Show all tables from database

Question

I would like to retrieve all the tables of my database as a list.

i tried to do a "Show databases" on a query but as i'm not using a class I defined (entity) in symfony it's not working.

And with DQL :

   $em = $this->getDoctrine()->getEntityManager();
   $query = $em->createQuery(
        'show databases');

    $result = $query->getResult();

This error :

[Syntax Error] line 0, col 0: Error: Expected SELECT, UPDATE or DELETE, got 'show'

Any idea to help me ?

Answer 1

As mentioned in a different answer, you can use Doctrine\DBAL for that:

/** @type \Doctrine\DBAL\Connection $connection */
$connection = ...;

/** @type \Doctrine\DBAL\Schema\MySqlSchemaManager $sm */
$sm = $connection->getSchemaManager();

And then just list the tables as Array:

var_dump( $sm->listDatabases() );