DROP INDEX (Selective XML Indexes)

Article
09/28/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

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

DROP clause

index_name
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

<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