Section courante

A propos

Section administrative du site

DROP INDEX

Supprime l'index
  Microsoft SQL Server

Syntaxe

DROP INDEX [ IF EXISTS ]
{ drop_relational_or_xml_or_spatial_index [ ,...n ]
| drop_backward_compatible_index [ ,...n ]
}

drop_relational_or_xml_or_spatial_index ::=
index_name ON object
[ WITH ( drop_clustered_index_option [ ,...n ] ) ]

drop_backward_compatible_index ::=
[ owner_name. ] table_or_view_name.index_name

::=
{ database_name.schema_name.table_or_view_name | schema_name.table_or_view_name | table_or_view_name }

drop_clustered_index_option ::=
{
MAXDOP = max_degree_of_parallelism
| ONLINE = { ON | OFF }
| MOVE TO { partition_scheme_name ( column_name )
| filegroup_name
| "default"
}
[ FILESTREAM_ON { partition_scheme_name
| filestream_filegroup_name
| "default" } ]
}
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 }
}

Description

Cette instruction permet d'enlever une ou plusieurs relation, spatial, filtre ou index XML de la base de données courante.



Dernière mise à jour : Vendredi, le 19 Juin 2020