function Schema::tableExists

Same name in this branch
  1. 11.x core/modules/sqlite/src/Driver/Database/sqlite/Schema.php \Drupal\sqlite\Driver\Database\sqlite\Schema::tableExists()
  2. 11.x core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::tableExists()
Same name in other branches
  1. 9 core/modules/sqlite/src/Driver/Database/sqlite/Schema.php \Drupal\sqlite\Driver\Database\sqlite\Schema::tableExists()
  2. 9 core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::tableExists()
  3. 9 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::tableExists()
  4. 8.9.x core/lib/Drupal/Core/Database/Driver/sqlite/Schema.php \Drupal\Core\Database\Driver\sqlite\Schema::tableExists()
  5. 8.9.x core/lib/Drupal/Core/Database/Driver/mysql/Schema.php \Drupal\Core\Database\Driver\mysql\Schema::tableExists()
  6. 8.9.x core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php \Drupal\Core\Database\Driver\pgsql\Schema::tableExists()
  7. 8.9.x core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::tableExists()
  8. 10 core/modules/sqlite/src/Driver/Database/sqlite/Schema.php \Drupal\sqlite\Driver\Database\sqlite\Schema::tableExists()
  9. 10 core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::tableExists()
  10. 10 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::tableExists()

Check if a table exists.

Parameters

$table: The name of the table in drupal (no prefixing).

bool $add_prefix: Boolean to indicate whether the table name needs to be prefixed.

Return value

bool TRUE if the given table exists, otherwise FALSE.

11 calls to Schema::tableExists()
Schema::addField in core/modules/mysql/src/Driver/Database/mysql/Schema.php
Add a new field to a table.
Schema::addIndex in core/modules/mysql/src/Driver/Database/mysql/Schema.php
Add an index.
Schema::addPrimaryKey in core/modules/mysql/src/Driver/Database/mysql/Schema.php
Add a primary key.
Schema::addUniqueKey in core/modules/mysql/src/Driver/Database/mysql/Schema.php
Add a unique key.
Schema::createTable in core/lib/Drupal/Core/Database/Schema.php
Create a new table from a Drupal table definition.

... See full list

2 methods override Schema::tableExists()
Schema::tableExists in core/modules/sqlite/src/Driver/Database/sqlite/Schema.php
Check if a table exists.
Schema::tableExists in core/modules/pgsql/src/Driver/Database/pgsql/Schema.php
Check if a table exists.

File

core/lib/Drupal/Core/Database/Schema.php, line 170

Class

Schema
Provides a base implementation for Database Schema.

Namespace

Drupal\Core\Database

Code

public function tableExists($table, bool $add_prefix = TRUE) {
    $condition = $this->buildTableNameCondition($table, '=', $add_prefix);
    $condition->compile($this->connection, $this);
    // Normally, we would heartily discourage the use of string
    // concatenation for conditionals like this however, we
    // couldn't use \Drupal::database()->select() here because it would prefix
    // information_schema.tables and the query would fail.
    // Don't use {} around information_schema.tables table.
    return (bool) $this->connection
        ->query("SELECT 1 FROM information_schema.tables WHERE " . (string) $condition, $condition->arguments())
        ->fetchField();
}

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.