function _db_maintenance_list_mysql_tables in DB Maintenance 5

Same name and namespace in other branches

1. 5.2 db_maintenance.module \_db_maintenance_list_mysql_tables()

Get a list of all the tables in a database.

Parameters

$db The name of the database connection to query for tables.:

Return value

An array representing the tables in the specified database.

2 calls to _db_maintenance_list_mysql_tables()

DBMaintenanceTableTest::testTableList in tests/table_list.test

db_maintenance_admin_settings in ./db_maintenance.module

Administration settings

File

./db_maintenance.module, line 90

Optimizes database tables during cron runs.

Code

function _db_maintenance_list_mysql_tables() {
  $table_names = array();

  // Set the database to query.
  $previous = db_set_active($db);
  $result = db_query('SHOW TABLES');

  // Return to the previously set database.
  db_set_active($previous);
  while ($table_name = db_fetch_array($result)) {
    $table_name = current($table_name);
    $table_names[$table_name] = $table_name;
  }
  return $table_names;
}