View Existing Validation Rules
On this page
You can view a collection's validation rules to determine what restrictions are imposed on documents and how MongoDB handles invalid documents when they occur.
To view a collection's validation rules, use the
db.getCollectionInfos()
method or listCollections
database command.
Both commands return the same information, but the output format differs between each command.
Prerequisite
To run the examples on this page, create a students
collection with
validation rules. For more information, see
Specify JSON Schema Validation.
Example: db.getCollectionInfos()
Syntax
The following command uses db.getCollectionInfos()
to return
the validation rules for the students
collection:
db.getCollectionInfos( { name: "students" } )[0].options.validator
The output resembles the following validation object:
{ '$jsonSchema': { bsonType: 'object', required: [ 'name', 'year', 'major', 'address' ], properties: { name: { bsonType: 'string', description: 'must be a string and is required' }, year: { bsonType: 'int', minimum: 2017, maximum: 3017, description: 'must be an integer in [ 2017, 3017 ] and is required' }, gpa: { bsonType: [ 'double' ], description: 'must be a double if the field exists' } } } }
Note
Validation Action and Level Not Included by Default
If validationAction
and validationLevel
are not explicitly
set, db.getCollectionInfos()
does not include those fields
in its output.
Example: listCollections
Syntax
The following command uses listCollections
to return the
validation rules for the students
collection:
db.runCommand ( { listCollections: 1, filter: { name: "students" } } )
The output resembles the following object:
{ cursor: { id: Long("0"), ns: 'test.$cmd.listCollections', firstBatch: [ { name: 'students', type: 'collection', options: { validator: { '$jsonSchema': { bsonType: 'object', required: [ 'name', 'year', 'major', 'address' ], properties: { name: { bsonType: 'string', description: 'must be a string and is required' }, gpa: { bsonType: [ 'double' ], description: 'must be a double if the field exists' } } }, validationAction: 'warn' } }, info: { readOnly: false, uuid: UUID("bf560865-5879-4ec1-b389-f77a03abbc5a") }, idIndex: { v: 2, key: { _id: 1 }, name: '_id_' } } ] }, ok: 1 }