protected function Schema::primaryKeyName in Drupal driver for SQL Server and SQL Azure 4.0.x

Same name and namespace in other branches

1. 4.2.x src/Driver/Database/sqlsrv/Schema.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Schema::primaryKeyName()
2. 3.1.x src/Driver/Database/sqlsrv/Schema.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Schema::primaryKeyName()
3. 4.1.x src/Driver/Database/sqlsrv/Schema.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Schema::primaryKeyName()

Return the name of the primary key of a table if it exists.

Parameters

mixed $table: Table name.

4 calls to Schema::primaryKeyName()

Schema::addPrimaryKey in src/Driver/Database/sqlsrv/Schema.php

Add a primary key.

Schema::cleanUpPrimaryKey in src/Driver/Database/sqlsrv/Schema.php

Drop the primary key constraint.

Schema::cleanUpTechnicalPrimaryColumn in src/Driver/Database/sqlsrv/Schema.php

Tries to clean up the technical primary column.

Schema::dropPrimaryKey in src/Driver/Database/sqlsrv/Schema.php

Drop the primary key.

File

src/Driver/Database/sqlsrv/Schema.php, line 1835

Class

Schema

Namespace

Drupal\sqlsrv\Driver\Database\sqlsrv

Code

protected function primaryKeyName($table) {
  $prefixInfo = $this
    ->getPrefixInfo($table, TRUE);
  $sql = 'SELECT name FROM sys.key_constraints WHERE parent_object_id = OBJECT_ID(:table) AND type = :type';
  return $this->connection
    ->query($sql, [
    ':table' => $prefixInfo['table'],
    ':type' => 'PK',
  ])
    ->fetchField();
}