How To Display Collections In Mongodb
Mongodb is a schema less database so it can store any number of fields to the documents.
How to display collections in mongodb. In a relational database like mysql a schema defines the organization structure of data in a database. Mongodb provides the db createcollection method to explicitly create a collection with various options such as setting the maximum size or the documentation validation rules. Mongodb show collection is a command from the mongodb shell that helps in listing the collections created in the current database. In this chapter we will learn how to query document from mongodb collection.
Find method displays the documents in a non structured format but to display the results in a formatted way the pretty method can be used. If you want to list the available collections in mongodb database all you need to do is select the mydb then run show collection command. Use mydb show collections output. A collection may store a number of documents.
When both authorizedcollections and nameonly options are set to true the command returns only those collections for which the user has privileges. It is similar to tables in mysql to store the records. A collection may store documents those who are not same in structure. To query data from mongodb collection you need to use mongodb s find method.
If we want to fetch all documents from the collection the following mongodb command can be used. Tecadmin accounts mycol pproducts users. First select the database you want to view the collection. To view the collection you need to select the one that you want to view.
Listcollections action on the database to run the command when access control is enforced. This is possible because mongodb is a schema free database. True that allows a user without the required privilege i e. If you are not specifying these options you do not need to explicitly create the collection since mongodb creates new collections when you first store data for the.
Mongodb show collection use show collections command from mongodb shell to list all collections created in the current database. Mongodb show collection select your database and run show collections command to list available collections in mongodb database. What is mongodb list collections. A collection is analogous to a table of an rdbms.