SQL Server/T-SQL Tutorial/System Functions/sp helpdb

EXEC sp_helpdb

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

EXEC sp_helpdb MyDatabase

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