SKIP_STRUCTURE_CHECKING
This option controls validation of materialized tables structure. It can have the following possible values:
| Value | Description |
|---|---|
TRUE | Structure check is disabled; default |
FALSE | Structure check is enabled |
Structure validation algorithm checks correspondence of the materialized table to its source table(s) and whether the materialized table is applicable for further usage. It does this by detecting the following:
- Changes in the structure (one or more columns could be added, removed, or renamed);
- Data type mismatch (the type of one or more columns could be changed).
Example
SQL
CALL SYSADMIN.setDefaultOptionValue('SKIP_STRUCTURE_CHECKING', 'FALSE');