protected function Schema::deleteCommentSql in Drupal driver for SQL Server and SQL Azure 3.0.x

Create an SQL statement to delete a comment.

2 calls to Schema::deleteCommentSql()

Schema::changeField in drivers/lib/Drupal/Driver/Database/sqlsrv/Schema.php

Change a field definition.

Schema::dropField in drivers/lib/Drupal/Driver/Database/sqlsrv/Schema.php

Should this be in a Transaction?

File

drivers/lib/Drupal/Driver/Database/sqlsrv/Schema.php, line 2005

Class

Schema

Namespace

Drupal\Driver\Database\sqlsrv

Code

protected function deleteCommentSql($table = NULL, $column = NULL) {
  $schema = $this
    ->getDefaultSchema();
  $prefixInfo = $this
    ->getPrefixInfo($table, TRUE);
  $prefixed_table = $prefixInfo['table'];
  $sql = "EXEC sp_dropextendedproperty @name=N'MS_Description'";
  $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;
}