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 3123 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

C Program to find the factorial of a number using Recursive function

Problem Write a program in C to find the factorial of a number using recursion and display the resu...

C Program to find the Sum of natural numbers

Problem Write a program in C to find the sum of natural numbers using recursive function. How to f...

C Program to display inverted full pyramid using *

Problem Write a program in C to print inverted full pyramid using * as shown below.The program shou...