Sp_helpdb - TSQL Tutorial

On Transact SQL language the sp_helpdb is part of Database Engine Stored Procedures and shows information about a specified database or all databases.

Sp_helpdb syntax:

sp_helpdb [ @dbname= 'Database name.' ] ;


Sp_helpdb example 1:

EXEC sp_helpdb;
GO

Sp_helpdb example 2:

EXEC sp_helpdb N'model';
GO