Export (0) Print
Expand All

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

Community Additions

© 2015 Microsoft