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!

Michael Berkowski · Accepted Answer · 2012-02-17 14:48:39Z

13

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

edited Feb 17, 2012 at 14:48

answered Jun 22, 2011 at 17:07

Michael Berkowski

271k47 gold badges452 silver badges395 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

grep Over a year ago

Perfect. Thank you. Correct in t minus 7 minutes.

GordyD · Accepted Answer · 2011-06-22 17:09:14Z

5

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

answered Jun 22, 2011 at 17:09

GordyD

5,10328 silver badges30 bronze badges

Comments

djdy · Accepted Answer · 2011-06-22 17:07:08Z

3

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

You can then do fetch on it.

answered Jun 22, 2011 at 17:07

djdy

6,9096 gold badges43 silver badges62 bronze badges

Comments

Ben · Accepted Answer · 2011-06-22 17:08:40Z

3

try this query :

"SHOW TABLES"

answered Jun 22, 2011 at 17:08

Ben

3052 silver badges6 bronze badges

Collectives™ on Stack Overflow

PHP PDO fetch all tables

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related