Getting List of All Server Databases in MS SQL

226 Reads Ms Sql

The following query should be run to get the list of all databases in the active instance in MS SQL Server.

SELECT Name FROM dbo.sysdatabases

Another method is as follows..

EXEC sp_databases
Ms Sql

You May Interest

Finding Server Default Language in MS SQL

What is an Index in SQL Server ?

What are the Limitations of Indexed Views in SQL Server ?

Making a Backup of MS SQL Database With Query

What is the Difference Between Clustered and a Non-clustered Inde ...