public function DatabaseSchema_sqlsrv::tableHasXmlIndex in Drupal driver for SQL Server and SQL Azure 7.2

Same name and namespace in other branches

1. 7.3 sqlsrv/schema.inc \DatabaseSchema_sqlsrv::tableHasXmlIndex()

Check if a table already has an XML index.

Parameters

string $table:

string $name:

3 calls to DatabaseSchema_sqlsrv::tableHasXmlIndex()

DatabaseSchema_sqlsrv::addPrimaryKey in sqlsrv/schema.inc

Override DatabaseSchema::addPrimaryKey().

DatabaseSchema_sqlsrv::createIndexSql in sqlsrv/schema.inc

Returns the SQL needed (incomplete) to create and index. Supports XML indexes.

DatabaseSchema_sqlsrv::dropIndex in sqlsrv/schema.inc

Override DatabaseSchema::dropIndex().

File

sqlsrv/schema.inc, line 1727

Database schema code for Microsoft SQL Server database servers.

Class

DatabaseSchema_sqlsrv

Code

public function tableHasXmlIndex($table) {
  $info = $this
    ->queryColumnInformation($table);
  if (isset($info['indexes']) && is_array($info['indexes'])) {
    foreach ($info['indexes'] as $name => $index) {
      if (strcasecmp($index['type_desc'], 'XML') == 0) {
        return $name;
      }
    }
  }
  return FALSE;
}