Check if a table exists.

Parameters

string $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.

12 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 195

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->condition('table_type', 'BASE TABLE');
  $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();
}

---