Delete all records of collection

Moralis General
#1

What is the recommended way to delete all records of a collection?

  1. Removing each field with entry.unset("fieldName")
  2. Iterating over all results and call entry.destroy
  3. Delete the collection? (=> How?)

I’m currently going through each result, which for quick testing seemed fine but is not really scaleable.

#2

you can delete all the rows of a table directly from your dashboard, you have something in the top right of the window that can do that, it will ask you to write the table name to confirm that you want to delete all the rows from that table

#3

It’s a bit cumbersome and takes 5 clicks + typing in the collection name. Which for 2 or 3 collections is really annoying with time.

I’m looking for a programmatic way to do the same.

#4

you could try Bulk Delete: https://docs.moralis.io/moralis-server/database/bulk-queries#bulk-delete

#5

Thanks! The BulkDeleteMany looks perfect, where can I find it under moralis/node? I don’t get it under Moralis.bulkDeleteMany ? (Is it just a typescript problem :thinking: )

#6

it may be accessible only from cloud code now

1 Like
#7

I see, will give it a try thanks !