drop-index-selective-xml-indexes.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	dev_langs
DROP INDEX (Selective XML Indexes)	DROP INDEX (Selective XML Indexes)	WilliamDAssafMSFT	wiassaf	08/10/2017	sql	t-sql	reference	DROP XML INDEX statement	TSQL

DROP INDEX (Selective XML Indexes)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]

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

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

DROP INDEX index_name ON <object>  
    [ WITH ( <drop_index_option> [ ,...n ] ) ]  
  
<object> ::=  
{ database_name.schema_name.table_or_view_name | schema_name.table_or_view_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