PHP PDO fetch all tables

So I know with a standard mysql call we can do mys开发者_开发技巧ql_list_tables , however is there an equivalent while using PDO? If so, does this return an array? Thanks!

Execute the query with PDO::query():

SHOW TABLES;

If you fetch an associative array, the name of the column will be:

Tables_in_databasename

Note: this will list both tables and views. If you must get only tables, use this instead:

SELECT 
  TABLE_NAME
FROM information_schema.TABLES 
WHERE
  TABLE_TYPE='BASE TABLE'
  AND TABLE_SCHEMA='yourdatabasename';

Do $pdo->query("show tables"); to obtain a result set of tables contained in the current database.

$result = $db->query("show tables");

You can then do fetch on it.

try this query :

"SHOW TABLES"