CODE SNIPPETS

All the Code Snippets and Samples you need

Microsoft SQL Server

How to list all databases in MSSQL

ByAdministrator

Jun 14, 2014 , , , , , , , , , ,

To list all databases in MSSQL you can use the following snippet.

Sample 1 MSSQL

SELECT name FROM master..sysdatabases

Sample 2 MSSQL

EXEC sp_databases

By Administrator

Related Post

Microsoft SQL Server

How to get the current Database and Log Filesize using MSSQL

May 22, 2015 Administrator
Microsoft SQL Server

How to drop Primary Key of a Table using MSSQL

Apr 21, 2015 Administrator
Microsoft SQL Server

How to search stored procedures using MS-SQL

Apr 15, 2015 Administrator
One thought on “How to list all databases in MSSQL”

Leave a Reply