List all tables of a database

<?php
 
$pdo = new PDO("mysql:host=localhost", "root", ""); 
 
$stmtnTable = $pdo->query('SHOW TABLES FROM `mysql`');
 
$tables_name = $stmtnTable->fetchAll(PDO::FETCH_COLUMN); 
 
foreach($tables_name as $tableName){ 

  echo $tableName, '<br>';

}
?>