Sp_databases - TSQL Tutorial

On Transact SQL language the sp_databases is part of Catalog Stored Procedures and return a list of databases from an instance of the SQL Server or are accessible through a database gateway.

Sp_databases syntax:

sp_databases ;


Sp_databases example:

USE model;
GO
EXEC sp_databases ;