Truncate a collection

mongodb mongodb-.net-driver
iefpw picture iefpw · May 11, 2013 · Viewed 73.4k times · Source

How do I truncate a collection in MongoDB or is there such a thing?

Right now I have to delete 6 large collections all at once and I'm stopping the server, deleting the database files and then recreating the database and the collections in it. Is there a way to delete the data and leave the collection as it is? The delete operation takes very long time. I have millions of entries in the collections.

Answer

astroanu picture astroanu · Apr 23, 2014

To truncate a collection and keep the indexes use

 db.<collection>.remove({})

Related questions

Redirect output of mongo query to a csv file

I am using MongoDB 2.2.2 for 32-bit Windows7 machine. I have a complex aggregation query in a .js file. I need to execute this file on the shell and direct the output to a CSV file. I ensure that the query …

Read More
How to get the Mongo database specified in connection string in C#

I would like to connect to the database specified in the connection string, without specifying it again in GetDatabase. For example, if I have a connection string like this; mongodb://localhost/mydb I would like to be able to db.…

Read More
How to replace substring in mongodb document

I have a lot of mongodb documents in a collection of the form: { .... "URL":"www.abc.com/helloWorldt/..." ..... } I want to replace helloWorldt with helloWorld to get: { .... "URL":"www.abc.com/helloWorld/..." ..... } How can I achieve this for all documents …

Read More