ADO.NET Provider for Certinia

Build 25.0.9434

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434