EXEC sp_helpdb MyDatabase : sp_helpdb « System Functions « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Functions
3. sp_helpdb

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