Domains behave as data types with optional built-in constraints. The main advantage of using domains is to have in one place a data type with a specific validation instead of creating separated columns in tables and applying to them the needed constraints to provide correctness when assigning values.
One simple example is an
|The default value for the domain. This field must be formatted according to the data type to be used.
|Indicates if the domain accepts null values or not.
|Data type effectively used by the domain.
|This tab groups the fields responsible for the creation of check expressions in the domain.
|The name of the check constraint to be created (on the tab
|The SQL expression assigned to a check constraint that is used to validate any value assigned to the domain (on the tab