protected function Schema::uniqueKeyExists in Drupal driver for SQL Server and SQL Azure 4.2.x
Same name and namespace in other branches
- 3.1.x src/Driver/Database/sqlsrv/Schema.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Schema::uniqueKeyExists()
- 4.0.x src/Driver/Database/sqlsrv/Schema.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Schema::uniqueKeyExists()
- 4.1.x src/Driver/Database/sqlsrv/Schema.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Schema::uniqueKeyExists()
Find if an unique key exists.
Parameters
mixed $table: Table name.
mixed $name: Index name.
Return value
bool Does the key exist?
4 calls to Schema::uniqueKeyExists()
- Schema::addUniqueKey in src/
Driver/ Database/ sqlsrv/ Schema.php - Add a unique key.
- Schema::changeField in src/
Driver/ Database/ sqlsrv/ Schema.php - Change a field definition.
- Schema::dropFieldRelatedObjects in src/
Driver/ Database/ sqlsrv/ Schema.php - Drop the related objects of a column (indexes, constraints, etc.).
- Schema::dropUniqueKey in src/
Driver/ Database/ sqlsrv/ Schema.php - Drop a unique key.
File
- src/
Driver/ Database/ sqlsrv/ Schema.php, line 1933
Class
Namespace
Drupal\sqlsrv\Driver\Database\sqlsrvCode
protected function uniqueKeyExists($table, $name) {
$prefixInfo = $this
->getPrefixInfo($table, TRUE);
return (bool) $this->connection
->query('SELECT 1 FROM sys.indexes WHERE object_id = OBJECT_ID(:table) AND name = :name', [
':table' => $prefixInfo['table'],
':name' => $name . '_unique',
])
->fetchField();
}