- Reference >
mongo
Shell Methods >- Collection Methods >
- db.collection.dropIndex()
db.collection.dropIndex()¶
On this page
Definition¶
-
db.collection.
dropIndex
(index)¶ Drops or removes the specified index from a collection. The
db.collection.dropIndex()
method provides a wrapper around thedropIndexes
command.Note
You cannot drop the default index on the
_id
field.The
db.collection.dropIndex()
method takes the following parameter:Parameter Type Description index
string or document Specifies the index to drop. You can specify the index either by the index name or by the index specification document. [1]
See Indexing Tutorials for information. To view all
indexes on a collection, use the
db.collection.getIndexes()
method.
Example¶
The following example uses the
db.collection.dropIndex()
method on the collectionpets
that has the following indexes:The index on the field
cat
has the user-specified name ofcatIdx
[2]. To drop the indexcatIdx
, you can use either the index name:or the index specification document
{ "cat" : 1 }
:
[1] When using a mongo
shell version earlier than 2.2.2, if you specified a name during the index creation, you must use the name to drop the index.
[2] During index creation, if the user does not specify an index name, the system generates the name by concatenating the index key field and value with an underscore, e.g. cat_1
.