sys.database_scoped_configurations (Transact-SQL)
Applies to: 
SQL Server 2016 (13.x) and later
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
SQL Endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
Contains one row per configuration.
| Column name | Data type | Description |
|---|---|---|
| configuration_id | int | ID of the configuration option. |
| name | nvarchar(60) | The name of the configuration option. For information about the possible configurations, see ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL). |
| value | sqlvariant | The value set for this configuration option for the primary replica. |
| value_for_secondary | sqlvariant | The value set for this configuration option for the secondary replicas. |
| is_value_default | bit | Specifies whether the value set is the default value. Added in SQL Server 2017. |
Permissions
Requires membership in the public role.
Remarks
When NULL is returned as the value for value_for_secondary, this means that the secondary is set to PRIMARY.
Database scoped configuration settings will be carried over with the database. This means that when a given database is restored or attached, the existing configuration settings remain.