Add SQL Defaults
Enable to add SQL Default constraints to tables created. SQL Defaults are always added to staging layer tables.
In the generated table definitions this controls the treatment of the BimlFlex system columns on SQL Server-family targets (MSSQL, SQLDB, SQLDW, FBRDW, FBRSQL, SQLMI): when enabled, the system columns are declared non-nullable so their SQL Default values are enforced; when disabled, they are left nullable. System columns on the Landing stage, and staging hash columns computed in SQL rather than by the custom SSIS components, remain nullable regardless.
When to Change This Setting
Keep the default N when the database does not need to enforce the system columns' defaults. Enable it when the system columns in generated tables should be declared NOT NULL with their SQL Default constraints enforced, for example when processes outside the generated loads insert into the tables and should inherit the defaults.
Related Settings
| Setting | Interaction |
|---|---|
| System Column Placement | Where the same system columns are placed in the table definition |
| Use User Null Assignment | The equivalent nullability control for user-defined columns |
Notes
- This setting is part of the Core settings category.
- The default value for this setting is
N.