SSIS Components for Microsoft SharePoint

Build 25.0.9434

ShowPredefinedColumns

Specifies whether the provider includes predefined columns, such as system or base-type columns, in metadata and query results.

データ型

bool

デフォルト値

true

解説

The ShowPredefinedColumns property determines whether predefined columns, those derived from a base type, are included in the metadata and query results. Predefined columns are typically system fields, such as CreatedBy, Author, and Modified, but can also include common columns like Title.

When set to true, these columns are included in the column listing.

When set to false, all columns derived from a base type are removed from the column listing, resulting in a cleaner, more focused set of fields.

This property applies to both the SOAP and REST schemas and is useful for simplifying metadata and query output by excluding default system columns when they are not needed.

Performance Considerations

Excluding predefined columns can reduce metadata size and simplify query results, which may improve performance and readability, especially in environments with large tables and many system-defined fields. Including them provides access to additional metadata, but can increase result set complexity.

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