How to fetch the tables list in database in Laravel 5.1

Question

I need to list out the tables in database, I found this query

SHOW TABLES LIKE  'merTrans%' 

to get the tables but how could I use the foreach to get the table names in Laravel 5.1?

Answer 1

To list out the tables in database you can do

$tables = DB::select('SHOW TABLES'); foreach($tables as $table) {       echo $table->Tables_in_db_name; } 

You'll have to change the db_name to the name of your database.

EDIT : FOR LIKE CASES

foreach ($tables as $table) {     foreach ($table as $key => $value)         echo $value; } 

Answer 2

I've been using this:

$tables = DB::connection()->getDoctrineSchemaManager()->listTableNames();

It requires doctrine/dbal as a dependency. But some migration features already need DBAL to work.