sp_databases SQL Server

SQL Server > System Stored Procedures > sp_databases

sp_databases lists databases that reside in an instance of the SQL Server Database .

Example:

USE master;

GO
EXEC sp_databases;

DATABASE_NAME           DATABASE_SIZE               REMARKS

action_plan        4160       NULL
master  4864       NULL
model   2624       NULL
msdb     13312    NULL
tempdb                2560       NULL