You can use db.getSiblingDB() method to access another database without switching the database.
To List Collections of PP database and query collection named “restaurants”
db.getSiblingDB('PP').getCollectionNames()
The PP Database has three collections
- first
- restaurants
- second
Accessing PP database temporarily from Test database
To access ‘restaurants’ collection of PP database
db.getSiblingDB('PP').restaurants.find().pretty();
OR
db.getSiblingDB('PP').restaurants.findOne();
Output:-
Like this:
Like Loading...
About Prashanth Jayaram
I’m a Database technologist having 11+ years of rich, hands-on experience on Database technologies. I am Microsoft Certified Professional and backed with a Degree in Master of Computer Application. My expertise lies in T-SQL programming, Replication and PowerShell
You can connect me via
https://social.technet.microsoft.com/profile/prashanth jayaram/
http://www.sqlshack.com/author/prashanth/
https://www.tumblr.com/blog/prashantjayaram
http://www.sqlservercentral.com/blogs/powersql-by-prashanth-jayaram/
http://www.toadworld.com/members/prashanthjayaram/
My Articles are published in following sites
http://www.ssas-info.com/analysis-services-articles/
http://db-pub.com/
http://www.sswug.org/sswugresearch/community/
