SQL Server 2014 Tutorial – List all the databases in SQL Server using Query

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: 1 (1 votes)

This article have been viewed 5597 times

Problem Statement

You need to list all the databases that are present in the current SQL Server instance.

Solution

The list of all the databases from the SQL Server instance can be obtained from the sys.databases object as shown below.

1. Open SQL Management Studio and connect to the SQL Server instance with your login details.

2. Click the "New Query" button and enter the below query in the Query window and click on the "Execute" button. This will display the databases that exists on the server in the results tab.

clip_image002

Note that this displays all the databases that you created along with the “system databases”.

1 Comment

  1. SQL Server 2014 Tutorial – Display System Databases in Object Explorer. | Abundant Code
    April 8, 2016 - 10:54 pm

Leave a Comment


x

You might be Interested in these Posts

Video - Angular Router - Brian Ford

Video - Angular Router - Brian Ford http://www.youtube.com/watch?v=sfV0ApyN5fM ...

Video - An Angular2 Todo App: First look at App Development in Angular2

In this screencast , David East , one of the core contributor of the Angular provides a glimpse of A...

Video - Getting started with Angular 2

In this screencast , Alex Eagle , developer on the Angular team talks about Angular 2 developer prev...