DROP INDEX (Selective XML Indexes)

SQL Server 2012

Drops an existing selective XML index or secondary selective XML index.

For more information, see the following topics:

Topic link icon Transact-SQL Syntax Conventions

        index_name ON <object>
    [ WITH ( <drop_index_option> [ ,...n ] ) ]

<object> ::=
    [ database_name. [ schema_name ] . | schema_name. ] 

<drop_index_option> ::=
    MAXDOP = max_degree_of_parallelism
    | ONLINE = { ON | OFF }

DROP clause


Is the name of the existing index to drop.

For example: DROP INDEX sxi_index

ON clause

< 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

For example: ON Tbl

WITH clause


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


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.

The following example shows a DROP INDEX statement.

DROP INDEX sxi_index ON tbl