Saturday , July 21 2018
Home / DataBase / SQL SERVER / View All Databases Information In SqlServer

View All Databases Information In SqlServer

 View All Databases Information In SqlServer:

There are different ways of listing all databases within an instance of SQL Server.

1.Sp_helpdb : Reports information about a specified database or all databases.

Example 1: exec Sp_helpdb



Example 2: exec Sp_helpdb ‘Construction’


2. sp_databases  : Reports all databases Names and Sizes

Example: EXEC sp_databases 



3. [sys].[databases] : Reports all databases details like databaseid,creation date,collation name etc

Example:  SELECT * FROM [sys].[databases]



Thanks for reading this article if you like this article please share with your Friends.

Print Friendly, PDF & Email

Give us your valuable feedback


About Murali

Hello everyone I am Software Developer having 3+ years of Experience in Microsoft Technologies and Others. My skills :-, C#,, SQL SERVER, web services, windows Service,Windows applications,HTML,CSS, JavaScript,JQuery,AnjularJs

Check Also

Find all rows count and columns count in single database in sql server

In General for any database it contains lot of tables, if we want to find …