protected function Schema::createCommentSql in Drupal driver for SQL Server and SQL Azure 3.1.x
Same name and namespace in other branches
- 4.2.x src/Driver/Database/sqlsrv/Schema.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Schema::createCommentSql()
- 4.0.x src/Driver/Database/sqlsrv/Schema.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Schema::createCommentSql()
- 4.1.x src/Driver/Database/sqlsrv/Schema.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Schema::createCommentSql()
Create the SQL statement to add a new comment.
2 calls to Schema::createCommentSql()
- Schema::addField in src/
Driver/ Database/ sqlsrv/ Schema.php - Add a new field to a table.
- Schema::createTableSql in src/
Driver/ Database/ sqlsrv/ Schema.php - Generate SQL to create a new table from a Drupal schema definition.
File
- src/
Driver/ Database/ sqlsrv/ Schema.php, line 2023
Class
Namespace
Drupal\sqlsrv\Driver\Database\sqlsrvCode
protected function createCommentSql($value, $table = NULL, $column = NULL) {
$schema = $this
->getDefaultSchema();
$value = $this
->prepareComment($value);
$prefixInfo = $this
->getPrefixInfo($table, TRUE);
$prefixed_table = $prefixInfo['table'];
$sql = "EXEC sp_addextendedproperty @name=N'MS_Description', @value={$value}";
$sql .= ",@level0type = N'Schema', @level0name = '{$schema}'";
if (isset($table)) {
$sql .= ",@level1type = N'Table', @level1name = '{$prefixed_table}'";
if (isset($column)) {
$sql .= ",@level2type = N'Column', @level2name = '{$column}'";
}
}
return $sql;
}