- Reference >
- Database Commands >
- Administration Commands >
- drop
drop¶
On this page
-
drop
¶ The
drop
command removes an entire collection from a database. The command has following syntax:The command takes the following fields:
Field Description drop The name of the collection to drop. writeConcern Optional. A document expressing the write concern of the
drop
command. Omit to use the default write concern.When issued on a sharded cluster,
mongos
converts the write concern of thedrop
command and its helperdb.collection.drop()
to"majority"
.The
mongo
shell provides the equivalent helper methoddb.collection.drop()
.
Behavior¶
This command also removes any indexes associated with the dropped collection.
Starting in MongoDB 4.0.2, dropping a collection deletes its associated zone/tag ranges.
The drop
command and its helper
db.collection.drop()
create an invalidate Event
for any Change Streams opened on the dropped collection.
Resource Locking¶
Changed in version 4.2.
drop
obtains an exclusive lock on the specified collection
for the duration of the operation. All subsequent operations on the
collection must wait until drop
releases the
lock.
Prior to MongoDB 4.2, drop
obtained an exclusive
lock on the parent database, blocking all operations on the
database and all its collections until the operation completed.