SQL Server/T-SQL/System/DATABASEPROPERTYEX

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

Displaying Database and SQL Server Settings

   <source lang="sql">

The DATABASEPROPERTYEX returns information about database options. DATABASEPROPERTYEX uses the following syntax: DATABASEPROPERTYEX ( database , property ) 8> 9> SELECT DATABASEPROPERTYEX("YourDatabaseName", "Collation"), 10> DATABASEPROPERTYEX("YourDatabaseName", "Recovery"), 11> DATABASEPROPERTYEX("YourDatabaseName", "Status") 12> GO -- NULL 

                                                                                NULL
                                         NULL

(1 rows affected) 

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