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 |
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