public function Schema::getComment in Drupal driver for SQL Server and SQL Azure 4.0.x
Same name and namespace in other branches
- 4.2.x src/Driver/Database/sqlsrv/Schema.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Schema::getComment()
- 3.1.x src/Driver/Database/sqlsrv/Schema.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Schema::getComment()
- 4.1.x src/Driver/Database/sqlsrv/Schema.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Schema::getComment()
Retrieve a table or column comment.
2 calls to Schema::getComment()
- Schema::changeField in src/
Driver/ Database/ sqlsrv/ Schema.php - Change a field definition.
- Schema::dropField in src/
Driver/ Database/ sqlsrv/ Schema.php - Should this be in a Transaction?
File
- src/
Driver/ Database/ sqlsrv/ Schema.php, line 2002
Class
Namespace
Drupal\sqlsrv\Driver\Database\sqlsrvCode
public function getComment($table, $column = NULL) {
$prefixInfo = $this
->getPrefixInfo($table, TRUE);
$prefixed_table = $prefixInfo['table'];
$schema = $this
->getDefaultSchema();
$column_string = isset($column) ? "'Column','{$column}'" : "NULL,NULL";
$sql = "SELECT value FROM fn_listextendedproperty ('MS_Description','Schema','{$schema}','Table','{$prefixed_table}',{$column_string})";
$comment = $this->connection
->query($sql)
->fetchField();
return $comment;
}