Add Constraints Columns to Table System.settings #7553 (vitaly Baranov)

Why it matters

This feature provides users with visibility into the constraints applied to server settings by including them directly in the system.settings table. It helps users understand validation rules and limits on configurable settings, improving manageability and observability.

How to use it

Query the system.settings table to see the new constraints column alongside other setting details, for example:

SELECT name, value, constraints FROM system.settings