PHP PDO fetch all tables

Question

So I know with a standard mysql call we can do mysql_list_tables , however is there an equivalent while using PDO? If so, does this return an array? Thanks!

Answer 1

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';

Answer 2

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