Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

DROP INDEX (Selective XML Indexes)

Drops an existing selective XML index or secondary selective XML index in SQL Server. For more information, see Selective XML Indexes (SXI).

Applies to: SQL Server (SQL Server 2012 through current version, SQL Database Update (preview).

Topic link icon Transact-SQL Syntax Conventions

DROP INDEX 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 }


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


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