Drop collection vs deleteMany in MongoDB

Introduction

We use drop to remove a whole collection and deleteMany to remove some or all documents inside a collection without deleting the collection itself.

When you want to completely remove a collection and all its data.

When you want to clear all or some documents but keep the collection structure.

When you want to reset a collection for fresh data without recreating it.

When you want to delete documents matching a specific condition.

When you want to free up space by removing unwanted documents but keep indexes.

Syntax

MongoDB

db.collection.drop()
db.collection.deleteMany(filter)

drop() removes the entire collection including indexes.

deleteMany(filter) removes documents matching the filter but keeps the collection and indexes.

Examples

Deletes the entire users collection and all its data.

MongoDB

db.users.drop()

Deletes all users younger than 18 but keeps the users collection.

MongoDB

db.users.deleteMany({ age: { $lt: 18 } })

Deletes all documents in the orders collection but keeps the collection itself.

MongoDB

db.orders.deleteMany({})

Sample Program

This example first inserts three products. Then it deletes products cheaper than 2 (Pen and Eraser). Next, it shows remaining products (Notebook). Finally, it drops the whole products collection and checks if it still exists.

MongoDB

use shopDB

// Create collection and insert sample data
db.products.insertMany([
  { name: "Pen", price: 1.5 },
  { name: "Notebook", price: 3 },
  { name: "Eraser", price: 0.5 }
])

// Delete all products cheaper than 2
const deleteResult = db.products.deleteMany({ price: { $lt: 2 } })

// Check remaining documents
const remaining = db.products.find().toArray()

// Drop the entire collection
const dropResult = db.products.drop()

// Check if collection exists
const collections = db.getCollectionNames()

Important Notes

After drop(), the collection no longer exists and must be recreated to add data again.

deleteMany({}) deletes all documents but keeps the collection and indexes intact.

Use drop() carefully because it removes everything including indexes.

Summary

drop() removes the entire collection and all data.

deleteMany(filter) removes documents matching the filter but keeps the collection.

Choose drop() to remove collection completely, deleteMany to clear data selectively.

Practice

1. What does the drop() method do in MongoDB?

easy

A. Removes the entire collection and all its documents

B. Deletes only one document from the collection

C. Removes documents matching a filter but keeps the collection

D. Renames the collection

Solution

1. Step 1: Understand drop() purpose

   The drop() method deletes the whole collection including all documents inside it.

2. Step 2: Compare with other methods

   Unlike deleteMany(), which removes documents but keeps the collection, drop() removes the collection itself.

3. Final Answer:

   Removes the entire collection and all its documents -> Option A

4. Quick Check:

   drop() removes collection [OK]

Hint: Drop removes collection; deleteMany removes documents only [OK]

Common Mistakes:

• Thinking drop() only deletes documents, not the collection
• Confusing deleteMany() with drop()
• Assuming drop() keeps collection structure

2. Which of the following is the correct syntax to delete all documents from a collection named users but keep the collection?

easy

A. db.users.removeCollection()

B. db.users.drop()

C. db.users.deleteOne({})

D. db.users.deleteMany({})

Solution

1. Step 1: Identify method to delete all documents

   deleteMany({}) with an empty filter deletes all documents but keeps the collection.

2. Step 2: Check other options

   drop() deletes the whole collection, deleteOne({}) deletes one document, and removeCollection() is invalid syntax.

3. Final Answer:

   db.users.deleteMany({}) -> Option D

4. Quick Check:

   deleteMany({}) deletes all docs, keeps collection [OK]

Hint: Use deleteMany({}) to clear all docs, not drop() [OK]

Common Mistakes:

• Using drop() which deletes the collection
• Using deleteOne() which deletes only one document
• Using non-existent removeCollection() method

3. Given a collection products with 100 documents, what will be the result after running db.products.deleteMany({ category: 'electronics' }) if 30 documents match the filter?

medium

A. All 100 documents are deleted and collection is dropped

B. 30 documents with category 'electronics' are deleted; 70 remain

C. No documents are deleted because filter is ignored

D. Collection is renamed to 'electronics'

Solution

1. Step 1: Understand deleteMany with filter

   The command deletes only documents matching the filter { category: 'electronics' }.

2. Step 2: Calculate remaining documents

   Since 30 documents match, they are deleted; 70 documents remain in the collection.

3. Final Answer:

   30 documents with category 'electronics' are deleted; 70 remain -> Option B

4. Quick Check:

   deleteMany(filter) deletes matching docs only [OK]

Hint: deleteMany(filter) deletes matching docs, not whole collection [OK]

Common Mistakes:

• Assuming deleteMany deletes entire collection
• Thinking filter is ignored
• Confusing deleteMany with drop

4. You want to remove all documents from the orders collection but accidentally run db.orders.dropMany({}). What is the issue?

medium

A. dropMany is not a valid MongoDB method

B. It deletes all documents but keeps the collection

C. It deletes only one document

D. It renames the collection

Solution

1. Step 1: Check method validity

   dropMany is not a valid MongoDB method; the correct methods are drop() and deleteMany().

2. Step 2: Understand consequences

   Since dropMany does not exist, this command will cause an error and no documents will be deleted.

3. Final Answer:

   dropMany is not a valid MongoDB method -> Option A

4. Quick Check:

   Invalid method causes error [OK]

Hint: Only drop() and deleteMany() exist; no dropMany() [OK]

Common Mistakes:

• Using dropMany() instead of deleteMany()
• Assuming dropMany deletes documents
• Confusing drop() and deleteMany() syntax

5. You want to completely remove a collection named logs only if it has fewer than 10 documents. Which sequence of commands correctly achieves this?

hard

A. Run db.logs.deleteMany({}) only

B. Run db.logs.deleteMany({}) then db.logs.drop()

C. Check count with db.logs.countDocuments(), then run db.logs.drop() if count < 10

D. Run db.logs.drop() without checking count

Solution

1. Step 1: Count documents in collection

   Use db.logs.countDocuments() to find how many documents exist.

2. Step 2: Conditionally drop collection

   If the count is less than 10, use db.logs.drop() to remove the entire collection.

3. Final Answer:

   Check count with db.logs.countDocuments(), then run db.logs.drop() if count < 10 -> Option C

4. Quick Check:

   Count first, then drop collection [OK]

Hint: Count documents first, then drop collection if condition met [OK]

Common Mistakes:

• Dropping collection without checking document count
• Deleting documents then dropping collection unnecessarily
• Using deleteMany() alone to remove collection