PDO query to fetch all tables

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