Kenhuang Academy
  • English

      • MongoDB Drop Collection

      MongoDB provides the ability to drop collections to clean up collections that are no longer needed. Dropping a collection removes all documents and indexes in the collection.

      Drop Collection Methods

      Basic Syntax

      db.collection.drop()

      Example

      // Drop users collection
db.users.drop()

// Returns true if drop successful
// Returns false if collection doesn't exist

      Check Before Drop

      // Check if collection exists
if (db.getCollectionNames().indexOf("users") >= 0) {
    db.users.drop()
    print("Collection dropped")
} else {
    print("Collection does not exist")
}

      Drop Collection Characteristics

      What Gets Dropped

      • All documents in the collection
      • All indexes of the collection
      • The collection itself

      What Remains

      • The database itself
      • Other collections
      • Database users and permissions

      Performance Characteristics

      • Drop operation is very fast (almost instantaneous)
      • Doesn't block other operations
      • Space is not immediately released (needs compact)

      Drop Multiple Collections

      Batch Drop

      // List of collections to drop
var collectionsToDrop = ["temp_logs", "cache_data", "old_records"]

collectionsToDrop.forEach(function(colName) {
    if (db.getCollectionNames().indexOf(colName) >= 0) {
        db.getCollection(colName).drop()
        print("Dropped collection:", colName)
    } else {
        print("Collection does not exist:", colName)
    }
})

      Drop All Collections (Keep Database)

      // Method 1: Iterate and drop
db.getCollectionNames().forEach(function(colName) {
    if (!colName.startsWith("system.")) {
        db.getCollection(colName).drop()
        print("Dropped:", colName)
    }
})

// Method 2: Using loop
var collections = db.getCollectionNames()
for (var i = 0; i < collections.length; i++) {
    var colName = collections[i]
    if (!colName.startsWith("system.")) {
        db[colName].drop()
    }
}

      Safe Drop Process

      Step 1: Backup Data

      # Export collection
mongodump --db mydb --collection users --out /backup/

# Or use mongoexport
mongoexport --db mydb --collection users --out /backup/users.json

      Step 2: Confirm Information

      // View collection statistics
db.users.stats()

// View document count
db.users.countDocuments()

// View indexes
db.users.getIndexes()

      Step 3: Execute Drop

      // Safe drop function
function safeDropCollection(colName) {
    // Confirm collection exists
    if (db.getCollectionNames().indexOf(colName) === -1) {
        print("Error: Collection does not exist -", colName)
        return false
    }
    
    // Get statistics
    var stats = db[colName].stats()
    print("Collection:", colName)
    print("Document count:", stats.count)
    print("Data size:", stats.size, "bytes")
    print("Index count:", stats.nindexes)
    
    // Execute drop
    var result = db[colName].drop()
    if (result) {
        print("Drop successful:", colName)
        return true
    } else {
        print("Drop failed:", colName)
        return false
    }
}

// Usage
safeDropCollection("users")

      Drop vs Empty Comparison

      drop() vs deleteMany()

      Featuredrop()deleteMany()
      What gets deletedCollection + documents + indexesDocuments only
      SpeedVery fastDepends on document count
      IndexesDroppedPreserved
      Space releaseNeeds compactNot released
      RecoverabilityLowCan rollback (in transactions)

      Empty Collection (Keep Structure)

      // Method 1: deleteMany
db.users.deleteMany({})

// Method 2: remove (deprecated)
db.users.remove({})

      Command Line Drop

      Non-Interactive Drop

      # Execute directly
mongosh --eval "db.getSiblingDB('mydb').users.drop()"

# With authentication
mongosh -u admin -p --authenticationDatabase admin --eval "db.getSiblingDB('mydb').users.drop()"

      Script Drop

      #!/bin/bash
# drop-collection.sh

DB_NAME=$1
COLLECTION_NAME=$2

if [ -z "$DB_NAME" ] || [ -z "$COLLECTION_NAME" ]; then
    echo "Usage: $0 <database_name> <collection_name>"
    exit 1
fi

# Backup
echo "Backing up collection..."
mongodump --db $DB_NAME --collection $COLLECTION_NAME --out /backup/

# Drop
echo "Dropping collection..."
mongosh --eval "db.getSiblingDB('$DB_NAME').$COLLECTION_NAME.drop()"

echo "Complete"

      Common Questions

      Q: Space not released after dropping?

      A: Use compact command to release space:

      // Compact database
db.runCommand({ compact: "users" })

      Q: How to recover accidentally dropped collection?

      A: Restore from backup:

      mongorestore --db mydb --collection users /backup/mydb/users.bson

      Q: How to drop system collections?

      A: Not recommended, but can use:

      db.system.indexes.drop()  // Use with caution!

      Summary

      Key points for dropping collections:

      • Operation is irreversible, backup before dropping
      • Drops collection, documents, and indexes simultaneously
      • Space is not immediately released
      • Faster and more thorough than deleteMany()

      In the next chapter, we will learn about MongoDB Insert Document.