SALES: 1-800-867-1380

DROP INDEX (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

This topic is not maintained. For the current version, see DROP INDEX.

Removes one or more relational, spatial, filtered, or XML indexes from the current database.

Syntax Conventions (Azure SQL Database)

{ <drop_relational_or_xml_or_spatial_index> [ ,...n ] 

<drop_relational_or_xml_or_spatial_index> ::=
    index_name ON <object> 

<object> ::=
    [ database_name. [ schema_name ] . | schema_name. ] 

This syntax diagram demonstrates the supported arguments and options in Microsoft Microsoft Azure SQL Database.

Microsoft Azure SQL Database does not support the following arguments and options when using the DROP INDEX statement:

  • database_name

  • <drop_backward_compatible_index>

  • <drop_clustered_index_option>

Microsoft Azure SQL Database supports the three-part name format database_name.[schema_name].object_name when the database_name is the current database or the database_name is tempdb and the object_name starts with #.

Microsoft Azure SQL Database does not support four-part names.

For more information about the arguments and the DROP INDEX statement, see DROP INDEX in SQL Server Books Online.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft