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

データ型

bool

デフォルト値

false

解説

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

When set to true, the 本製品 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.