DATABASEPROPERTYEX()

Signature

DATABASEPROPERTYEX ( database , property )

Parameters

• database — An expression specifying the name of the database for which `DATABASEPROPERTYEX` returns the named property information. *database* has an nvarchar(128) data type.
• property — An expression specifying the name of the database property to return. *property* has a varchar(128) data type, and supports one of the values in this table:

Examples

SELECT DATABASEPROPERTYEX('AdventureWorks2022', 'IsAutoShrink');

NULL

SELECT DATABASEPROPERTYEX('AdventureWorks2022', 'Collation') AS Collation,
       DATABASEPROPERTYEX('AdventureWorks2022', 'Edition') AS Edition,
       DATABASEPROPERTYEX('AdventureWorks2022', 'ServiceObjective') AS ServiceObjective,
       DATABASEPROPERTYEX('AdventureWorks2022', 'MaxSizeInBytes') AS MaxSizeInBytes;

NULL|NULL|NULL|NULL

SELECT DATABASEPROPERTYEX(DB_NAME(), 'Updateability');

READ_WRITE

Run against SQL Server 16.0.4265.3 on 2026-09-13. This is the output we got, not the documentation’s.

Available on

• SQL Server 2017 and later
• Azure SQL Database
• Azure SQL Managed Instance
• Azure Synapse Analytics
• Analytics Platform System (PDW)
• Fabric SQL database