SQL Server/T-SQL Tutorial/System Functions/sp helpdb
EXEC sp_helpdb
<source lang="sql">
3> EXEC sp_helpdb name db_size owner
dbid created status
compatibility_level
------------- ---------------------------------------------------------
------ ----------- -------------------------------------------------------------------------------------------------------------
-------------------
ClubRoster 1.68 MB J\Administrator
5 Aug 17 2008 Status=SUSPECT, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, IsAutoClose, I
sAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled
90
master 4.75 MB sa
1 Apr 8 2003 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L
atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics
90
model 1.69 MB sa
3 Apr 8 2003 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L
atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics
90
msdb 4.94 MB sa
4 Oct 14 2005 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L
atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled
90
ProSSEAppsCh07 1.68 MB J\Administrator
6 Aug 17 2008 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L
atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoClose, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled
90
tempdb 2.50 MB sa
2 Aug 17 2008 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L
atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics</source>
EXEC sp_helpdb MyDatabase
<source lang="sql">
3> CREATE DATABASE MyDatabase 4> GO 1> EXEC sp_helpdb MyDatabase 2> GO name db_size owner
dbid created status
compatibility_level
------------- ---------------------------------------------------------
------ ----------- -------------------------------------------------------------------------------------------------------------
-------------------
MyDatabase 1.68 MB J\Administrator
6 Aug 17 2008 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L
atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoClose, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled
90
name fileid filename
fil
egroup size maxsize growth usage
------ ----------------------------------------------------------------
---
------------------ ------------------ ------------------ ---------
MyDatabase 1 c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Databas e_2.mdf PRI MARY 1216 KB Unlimited 1024 KB data only MyDatabase_log 2 c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Databas e_2_log.LDF NUL L 504 KB 2147483648 KB 10% log only 1> DROP DATABASE MyDatabase 2> GO</source>
