Database Manual / Introduction / Databases & Collections / Views

Modify or Remove a View

To remove a view, use the db.collection.drop() method on the view.

To modify a view, you can either:

Example

Consider the following view named lowStock:

db.createView(
   "lowStock",
   "products",
   [ { $match: { quantity: { $lte: 20 } } } ]
)

Drop and Recreate the View

The following commands modify lowStock by dropping and recreating the view:

db.lowStock.drop()

db.createView(
   "lowStock",
   "products",
   [ { $match: { quantity: { $lte: 10 } } } ]
)

Use the collMod Command

Alternatively, you can use the collMod command to modify the view:

db.runCommand( {
   collMod: "lowStock",
   viewOn: "products",
   "pipeline": [ { $match: { quantity: { $lte: 10 } } } ]
} )