drop-index-selective-xml-indexes.md

title	DROP INDEX (Selective XML Indexes) | Microsoft Docs
ms.custom
ms.date	08/10/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	DROP XML INDEX statement
dev_langs	TSQL
ms.assetid	4779ae84-e5f4-4d04-8fc1-e24a6631b428
caps.latest.revision	12
author	douglaslMS
ms.author	douglasl
manager	jhubbard

DROP INDEX (Selective XML Indexes)

[!INCLUDEtsql-appliesto-ss2012-asdb-xxxx-xxx_md]

Drops an existing selective XML index or secondary selective XML index in [!INCLUDEssNoVersion]. For more information, see Selective XML Indexes (SXI).

Transact-SQL Syntax Conventions

Syntax

DROP INDEX index_name ON <object>  
    [ WITH ( <drop_index_option> [ ,...n ] ) ]  
  
<object> ::=  
{  
    [ database_name. [ schema_name ] . | schema_name. ]   
        table_or_view_name  
}  
  
<drop_index_option> ::=  
{  
    MAXDOP = max_degree_of_parallelism  
    | ONLINE = { ON | OFF }  
}  

Arguments

index_name
Is the name of the existing index to drop.

< object> Is the table that contains the indexed XML column. Use one of the following formats:

• database_name.schema_name.table_name

• database_name..table_name

• schema_name.table_name

• table_name

<drop_index_option> For information about the drop index options, see DROP INDEX (Transact-SQL).

Security

Permissions

ALTER permission on the table or view is required to run DROP INDEX. This permission is granted by default to the sysadmin fixed server role and the db_ddladmin and db_owner fixed database roles.

Example

The following example shows a DROP INDEX statement.

DROP INDEX sxi_index ON tbl;  

See Also

Selective XML Indexes (SXI)
Create, Alter, and Drop Selective XML Indexes