Related Articles

Related Articles

DATABASEPROPERTYEX() in SQL Server
  • Last Updated : 28 Sep, 2020

DATABASEPROPERTYEX()
It is the function used to return the different information about the current setting of the specified database option or property.

Syntax :

DATABASEPROPERTYEX ( 'databasename', 'propertyname' )  

Now, here you will see the property description as following.

  • databasename :
    It is the name of the database for which DATABASEPROPERTYEX will result in the property name information, databasename has an nvarchar(128) data type.

  • propertyname :
    It is an expression that defines the name of the database property to have resulted, propertyname has varchar(128) data type.

The following are a few property names that DATABASEPROPERTYEX() function provides info.



  1. Collation :
    This property defines the default collation name for the database.

  2. ComparisonStyle :
    This property defines the Windows comparison variety of the collation.

  3. Edition :
    This property defines the database edition or service tier.

  4. IsAnsiNullDefault :
    This property defines if the database follows ISO rules for permitting null values.

  5. IsAnsiNullsEnabled :
    This property defines all comparisons to a null assessment to the unknown.

  6. IsAnsiPaddingEnabled :
    This property defines strings are padded to the identical length before comparison or insert.

  7. IsAnsiWarningsEnabled :
    This property defines SQL Server issues an error or warning messages once commonplace error conditions occur.

  8. IsArithmeticAbortEnabled :
    This property defines queries to finish once an overflow or divide-by-zero error happens throughout query execution.



  9. IsAutoClose :
    This property defines the database shuts down cleanly and frees resources when the last user exits.

  10. IsAutoCreateStatistics :
    This property defines query optimizer creates single-column statistics, as needed, to boost query performance.

  11. IsAutoCreateStatisticsIncremental :
    This property defines auto-created single-column statistics are incremental once possible.

  12. IsAutoShrink :
    This property defines database files are candidates for automatic periodic shrinking.

  13. IsAutoUpdateStatistics :
    This property defines when a query uses potentially out-of-date existing statistics, the query optimizer updates those statistics.

  14. IsClone :
    This property defines a database might be a schema- and statistics only copy of a user database created with DBCC CLONE DATABASE.

  15. IsCloseCursorsOnCommitEnabled :
    This property defines when a transaction commits, all open cursors will close.

  16. IsFulltextEnabled :
    This property defines the database is enabled for full-text and linguistics indexing.

  17. IsInStandBy :
    This property defines database is online as read-only, with restore log allowed.

  18. IsLocalCursorsDefault :
    This property defines pointer declarations default to native.



  19. IsNullConcat :
    This property defines null concatenation operand yields NULL.

  20. IsNumericRoundAbortEnabled :
    This property defines errors are generated once a loss of precision happens in expressions.

  21. IsQuotedIdentifiersEnabled :
    This property defines double quotation marks on identifiers are allowed.

  22. IsPublished :
    This property defines if replication is there, SQL Server supports database table publication for replication.

  23. IsRecursiveTriggersEnabled :
    This property defines the recursive firing of triggers is enabled.

  24. IsSubscribed :
    This property defines the database is subscribed to a publication.

  25. IsSyncWithBackup :
    This property defines the database is either a broadcast database or a distributed database, and it supports a restoration that is able to not disrupt transnational replication.

  26. IsTornPageDetectionEnabled :
    This property defines the SQL Server Database Engine detects incomplete I/O operations caused by power failures or different system outages.

  27. IsXTPSupported :
    This property indicates whether the database supports In-Memory OLTP.

Examples –
Here is the screenshot.

My Personal Notes arrow_drop_up
Recommended Articles
Page :