SQL Server 2014 Tutorial – Display System Databases in Object Explorer.

Published on April 8, 2016 by abundantcode

Filed under SQL Server

Last modified April 8, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 3 (1 votes)

This article have been viewed 1756 times

Problem Statement

You need to view the System Databases in Object Explorer.


By default , there are few System databases that gets created when you install SQL Server. Some of these databases are

  • master – This is the primary system database which is needed for the SQL Server to start and work fine. It contains the information about databases , logins , configurations etc.
  • tempdb – When you create a temporary table or stored procedures etc. , this is the database that plays an important role. This table would be recreated every time the SQL Server is restarted.
  • model – This database contains the model for all the databases that are created on the server. When you create a new database on the server , the template is picked from the model database.
  • msdb – The database used by the Microsoft SQL Server Agent which stores the metadata when a SQL Server Agent job is scheduled. This also contains the maintenance plans.

The above system databases are for the Express edition of the SQL Server 2014 . You might see more system databases depending on the version of the SQL Server installed.

To view the System databases in Object explorer , follow the below steps

1. Open SQL Server 2014 Management Studio and connect to the server with your login credentials.

2. In the Object explorer , Expand databases to see the folder "System Databases". Expand it to see the list of System databases.


If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment


You might be Interested in these Posts

How to get the Number of Elements in an Array in C# ?

You can use the Length property of the array to return the number of elements in it. Note that once ...

How to get the Machine Name from a .NET Application using C# ?

You can use the MachineName property defined in the System.Environment class in order to get the Mac...

How to append an array to another in JavaScript ?

In JavaScript , you may want to append one array to another array(s) to combine their elements resul...