SQL Server/T-SQL/Database/Database Info

Материал из SQL эксперт
Перейти к: навигация, поиск

Database info message

   <source lang="sql">

1> CREATE DATABASE Database_2 2> GO 1> EXEC sp_helpdb Database_2 2> GO name db_size owner dbid created status compatibility_level

Database_2 1.68 MB sqle\Joe 

                                                                                                5 Oct 14 2006 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recov

ery=SIMPLE, Version=611, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoClose, IsAutoCreateStatistics, 

                IsAutoUpdateStatistics, IsFullTextEnabled
        90

name fileid filename 

                                    filegroup                                                                                                                        size
    maxsize            growth             usage
------ --------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------- --------------
------------------ ------------------ ---------

Database_2 1 c:\Program Files\Microsoft SQL Server\MSSQL. 1\MSSQL\DATA\Database_2.mdf 

                                    PRIMARY                                                                                                                          1216 KB
    Unlimited          1024 KB            data only

Database_2_log 2 c:\Program Files\Microsoft SQL Server\MSSQL. 1\MSSQL\DATA\Database_2_log.LDF 

                                    NULL                                                                                                                             504 KB
    2147483648 KB      10%                log only

1> DROP DATABASE Database_2 2> GO 1> 

      </source>
Источник — «http://sqle.ru/index.php?title=SQL_Server/T-SQL/Database/Database_Info&oldid=5605»