Reports information about a specified database or all databases.
sp_helpdb [dbname]
where
When dbname is specified, sp_helpdb reports on that database. When no parameter is supplied, sp_helpdb reports on all databases in master.dbo.sysdatabases.
This example displays the following information about the pubs database:
sp_helpdb pubs
This example displays information about all databases on the SQL Server but does not include the device_fragments, size, and usage columns.
sp_helpdb
Execute permission defaults to the public group.
master.dbo.spt_values, master.dbo.sysdatabases, master.dbo.sysdevices, master.dbo.syslogins, master.dbo.sysusages
ALTER DATABASE | sp_dboption |
CREATE DATABASE | sp_renamedb |
sp_configure |