Need to delete mongodb collection with prefix based name

Question

I have number of collection in my mongodb.

The collections names are like aaa_123,aaa_345,aaa_ccc,mmm,nnn and etc...

Many collections name has prefixed with aaa_ and also other collection name also present, I need to delete only the collection names prefixed with aaa_ , but in manual I deleted like db.aaa_123.drop(), its take long time to delete collection , Is there anyway to delete all collections with prefixed aaa_ in mongodb?

Anyhelp appreciated..

db.getCollectionInfos({ "name": /^aaa/ }).forEach( i => db.getCollection(i.name).drop() ) — Neil Lunn
– Neil Lunn, Commented Aug 11, 2017 at 7:16

charan tej · Accepted Answer · 2017-08-11 07:24:50Z

3

First Get all collection in DB to one variable then loop through that variable and check for that name in collection. If that check condition satisfies delete that collection. Check below for code sample

var collectionNames = db.getCollectionNames();
for(var i = 0, len = collectionNames.length; i < len ; i++){
    var collectionName = collectionNames[i];
    if(collectionName.indexOf('aaa_') == 0){
        db[collectionName].drop()
    }
}

Hope this helps

answered Aug 11, 2017 at 7:24

charan tej

1,05211 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Need to delete mongodb collection with prefix based name

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related