DrupalAPI.de

1. drupal
   1. drupal7

Find all tables that are like the specified base table name.

Übergabeparameter

$table_expression An SQL expression, for example "simpletest%" (without the quotes). BEWARE: this is not prefixed, the caller should take care of that.

Rückgabewert

Array, both the keys and the values are the matching tables.

Verwandte Themen

Schema API

A Drupal schema definition is an array structure representing one or more tables and their related keys and indexes. A schema is defined by hook_schema(), which usually lives in a modulename.install file.

Code

includes/database/schema.inc, line 203

<?php
public function findTables($table_expression) {
  $condition = $this->buildTableNameCondition($table_expression, 'LIKE');
  $condition->compile($this->connection);
  // Normally, we would heartily discourage the use of string
  // concatination for conditionals like this however, we
  // couldn't use db_select() here because it would prefix
  // information_schema.tables and the query would fail.
  // Don't use {} around information_schema table.
  return db_query("SELECT table_name FROM information_schema.tables WHERE " . (string) $condition, $condition->arguments())->fetchAllKeyed(0, 0);
}
?>