Example

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.

Selective XML Indexes (SXI)

Create, Alter, and Drop Selective XML Indexes

See Also

DROP
INDEX sxi_index
ON tbl;