CData Python Connector for Microsoft Excel Online

Build 25.0.9454

IncludePrimaryKey

Controls whether the driver includes an auto-generated primary key column in the table definition.

Data Type

bool

Default Value

true

Remarks

When IncludePrimaryKey is set to True (default), the driver adds a primary key column (id) to each table. The column name can be customized using the PrimaryKeyIdentifier property. When IncludePrimaryKey is set to False, the driver omits the auto-generated primary key column entirely and returns only the columns defined in the source data.

Disabling this option forces the driver to search all matching rows instead of relying directly on the primary key column. This impacts performance for UPDATE and DELETE operations.

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