Specifies whether updates are allowed on tables that do not have a defined primary key.

Data Type

bool

Default Value

false

Remarks

When set to false, update operations require a primary key to ensure the component can uniquely identify rows. This prevents unintended data changes and maintains consistent behavior across write operations.

When set to true, the component allows updates even if the target table does not have a primary key. In this case, all rows that match the update condition are affected, which can lead to broader updates than expected.

Enable this property only if you are confident in the filtering logic of your update queries and understand the risk of modifying non-uniquely identifiable rows.

Allowing updates without a primary key can trigger full table scans and may degrade performance, especially with large datasets. Use this option with caution.