- Reference >
mongo
Shell Methods >- Collection Methods >
- db.collection.dropIndexes()
db.collection.dropIndexes()¶
On this page
Definition¶
-
db.collection.
dropIndexes
()¶ Important
mongo
Shell MethodThis page documents a
mongo
method. This is not the documentation for database commands or language-specific drivers, such as Node.js. To use the database command, see thedropIndexes
command.For MongoDB API drivers, refer to the language-specific MongoDB driver documentation.
Drops the specified index or indexes (except the index on the
_id
field) from a collection.You can use the method to:
Drop all but the
_id
index from a collection.Drop a specified index from a collection. To specify the index, you can pass the method either:
The index specification document (unless the index is a text index in which case, use the index name to drop):
The index name:
Tip
To get the names of the indexes, use the
db.collection.getIndexes()
method.
Drop specified indexes from a collection. (Available starting in MongoDB 4.2). To specify multiple indexes to drop, pass the method an array of index names:
If the array of index names includes a non-existent index, the method errors without dropping any of the specified indexes.
Tip
To get the names of the indexes, use the
db.collection.getIndexes()
method.
The
db.collection.dropIndexes()
method takes the following optional parameter:Parameter Type Description indexes
string or document or array of strings Optional. Specifies the index or indexes to drop.
To drop all but the _id index from the collection, omit the parameter.
To drop a single index, specify either the index name, the index specification document (unless the index is a text index), or an array of the index name. To drop a text index, specify the index name or an array of the index name instead of the index specification document.
To drop multiple indexes (Available starting in MongoDB 4.2), specify an array of the index names.
Behavior¶
Resource Locking¶
Changed in version 4.2.
db.collection.dropIndexes()
obtains an exclusive lock on the specified collection
for the duration of the operation. All subsequent operations on the
collection must wait until db.collection.dropIndexes()
releases the
lock.
Prior to MongoDB 4.2, db.collection.dropIndexes()
obtained an exclusive
lock on the parent database, blocking all operations on the
database and all its collections until the operation completed.
Dropping an Index during Index Replication¶
Avoid dropping an index on a collection while any index is being replicated on a secondary. If you attempt to drop an index from a collection on a primary while the collection has a background index building on a secondary, reads will be halted across all namespaces and replication will halt until the background index build completes.
Index Names¶
If the method is passed an array of index names that includes a non-existent index, the method errors without dropping any of the specified indexes.
_id
Index¶
You cannot drop the default index on the _id
field.