sys.database_scoped_configurations (Transact-SQL)sys.database_scoped_configurations (Transact-SQL)

适用对象:yesSQL Server(从 2016 版开始)yesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server (starting with 2016) yesAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

包含每个配置的一行。Contains one row per configuration.

列名Column name 数据类型Data type DescriptionDescription
configuration_idconfiguration_id intint 配置选项的 ID。ID of the configuration option.
名称name nvarchar(60)nvarchar(60) 配置选项的名称。The name of the configuration option. 有关可能的配置信息,请参阅ALTER DATABASE SCOPED CONFIGURATION (TRANSACT-SQL)For information about the possible configurations, see ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL).
valuevalue sqlvariantsqlvariant 对于主副本此配置选项设置的值。The value set for this configuration option for the primary replica.
value_for_secondaryvalue_for_secondary sqlvariantsqlvariant 设置次要副本的此配置选项的值。The value set for this configuration option for the secondary replicas.
is_value_defaultis_value_default bitbit 指定设置的值是否为默认值。Specifies whether the value set is the default value.

PermissionsPermissions

要求 公共 角色具有成员身份。Requires membership in the public role.

备注Remarks

值返回 NULL value_for_secondary,这意味着,辅助数据库设置为主要。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.

请参阅See Also

ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)