Specifies which columns to use when filtering rows during update or delete operations on tables without primary keys.

データ型

string

デフォルト値

""

解説

This property is only applicable when AllowUpdatesWithoutKey is set to true. When a table does not have a primary key, the 本製品 uses the columns specified here to identify matching rows for update or delete operations.

Set this property as a comma-separated list of column names. For example:

FilterColumns=col1,col2,col3

The specified columns are used to construct the WHERE clause during write operations.

Use this property to define a set of columns that uniquely identify rows when working with tables that lack a primary key.

Choosing too few or non-unique columns can result in broader updates or deletes than intended. Review your dataset carefully to avoid accidental data modification.