Skip to main content

Constraint Mode

The table reference constraint mode to apply for the Data Vault database. Allowed values are DoNotCreate, CreateAndNoCheck and CreateAndCheck.

Options: DoNotCreate, CreateAndNoCheck, CreateAndCheck

OptionBehavior
DoNotCreate (default)No reference constraints are modeled for Data Vault tables
CreateAndNoCheckReference constraints are modeled but not enforced against existing data
CreateAndCheckReference constraints are modeled and enforced

A blank or unrecognized value is treated as DoNotCreate.

When to Change This Setting​

Keep the default DoNotCreate for a standard Data Vault, where load order and zero keys manage referential completeness and physical constraints would slow highly parallel loads. Use the create options when you want the table relationships expressed as constraints, for example to expose the model's relationships to tooling.

SettingInteraction
Constraint Mode STGThe equivalent control for Staging tables
Constraint Mode DMThe equivalent control for Data Mart tables

Notes​

  • This setting is part of the Data Vault settings category.
  • The default value for this setting is DoNotCreate.