Class DatabasesAndFilesSchema.DatabaseScopedConfiguration

sys.database_scoped_configurations (Transact-SQL)

APPLIES TO: (Yes) SQL Server 2016 and later (Yes) Azure SQL Database (Yes) Azure Synapse Analytics (No) Parallel Data Warehouse

Contains one row per configuration.

[Table(Schema = "sys", Name = "database_scoped_configurations", IsView = true)]
public class DatabasesAndFilesSchema.DatabaseScopedConfiguration

Properties

ID of the configuration option.

[Column("configuration_id")]
[Nullable]
public int? ConfigurationID { get; set; }

Specifies whether the value set is the default value. Added in SQL Server 2017.

[Column("is_value_default")]
[Nullable]
public bool? IsValueDefault { get; set; }

The name of the configuration option. For information about the possible configurations, see ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL).

[Column("name")]
[Nullable]
public string? Name { get; set; }

The value set for this configuration option for the primary replica.

[Column("value")]
[Nullable]
public object? Value { get; set; }

The value set for this configuration option for the secondary replicas.

[Column("value_for_secondary")]
[Nullable]
public object? ValueForSecondary { get; set; }