ContinueOnAlterException
Specifies whether the provider should continue executing subsequent ALTER statements after one fails.
Data Type
bool
Default Value
false
Remarks
When modifying table schemas, Certinia imposes a limit on the number of columns that can be altered in a single ALTER statement. To comply with this, the provider automatically splits ALTER statements into multiple smaller statements, each modifying up to 10 columns.
If ContinueOnAlterException is set to true, the provider continues executing remaining ALTER statements even if one fails. If set to false, the process stops immediately when an error occurs.
Setting this property to true allows schema modifications to proceed partially even when some statements fail, which can be useful for batch updates or non-critical column modifications. However, enabling this may result in inconsistent table structures if some changes succeed while others fail.
This property is useful when performing schema updates on Certinia objects while needing to balance error handling and execution continuity.