Concepts > Attributes (MetaAttributes) > ENFORCED \ DB2 10.5
ENFORCED \ DB2 10.5
NOT ENFORCED:
Specifies that the constraint is not enforced by the database manager
during normal operations such as insert, update, or delete.
TRUSTED:
The data can be trusted to conform to the constraint. TRUSTED must
be used only if the data in the table is independently known to
conform to the constraint. Query results might be unpredictable if the
data does not actually conform to the constraint. This is the default
option.
NOT TRUSTED:
The data cannot be trusted to conform to the constraint. NOT
TRUSTED is intended for cases where the data conforms to the
constraint for most rows, but it is not independently known that all the
rows or future additions will conform to the constraint. If a constraint
is NOT TRUSTED and enabled for query optimization, then it will not
be used to perform optimizations that depend on the data conforming
completely to the constraint. NOT TRUSTED can be specified only for
referential integrity constraints (SQLSTATE 42613).
Translations
Type
String (63) Enumeration
 
List of MetaClasses
Value
(1), (2), (3), (4).