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.

2 methods override DatabaseSchema::findTables()

DatabaseSchema_pgsql::findTables in includes/database/pgsql/schema.inc

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

DatabaseSchema_sqlite::findTables in includes/database/sqlite/schema.inc

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

File

includes/database/schema.inc, line 342

Class

DatabaseSchema

Base class for database schema definitions.

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 AS table_name FROM information_schema.tables WHERE " . (string) $condition, $condition->arguments ())
 ->fetchAllKeyed (0, 0);
}

---