DROP INDEX (Selective XML Indexes)

Article
2022-12-29

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

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

Transact-SQL syntax conventions

Syntax

syntaxsql

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.

SQL

DROP INDEX sxi_index ON tbl;

Share via