public function DatabaseSchema::findTables
public DatabaseSchema::findTables($table_expression)
Find all tables that are like the specified base table name.
Parameters
$table_expression: An SQL expression, for example "simpletest%" (without the quotes). BEWARE: this is not prefixed, the caller should take care of that.
Return value
Array, both the keys and the values are the matching tables.
File
- includes/database/schema.inc, line 334
- Generic Database schema code.
Class
Code
public function findTables($table_expression) { $condition = $this->buildTableNameCondition($table_expression, 'LIKE', FALSE); $condition->compile($this->connection, $this); // Normally, we would heartily discourage the use of string // concatenation 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.tables table. return $this->connection->query("SELECT table_name FROM information_schema.tables WHERE " . (string) $condition, $condition->arguments())->fetchAllKeyed(0, 0); }
© 2001–2016 by the original authors
Licensed under the GNU General Public License, version 2 and later.
Drupal is a registered trademark of Dries Buytaert.
https://api.drupal.org/api/drupal/includes!database!schema.inc/function/DatabaseSchema::findTables/7.x