Home > mongodb > [mongodb] drop all indexes of a database

[mongodb] drop all indexes of a database

Problem
You have a database with several collections in it. You want to drop all the indexes of these collections.

Solution

use name_of_your_database;

db.getCollectionNames().forEach(function(collName) {
    db.runCommand({dropIndexes: collName, index: "*"});
});

Tip from here.

Categories: mongodb Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: