ADO.NET Provider for Azure Synapse

Build 25.0.9434

IncludeTableTypes

Specifies whether the provider retrieves the object type (table or view) for each entry it returns during metadata queries.

Data Type

bool

Default Value

true

Remarks

When this property is set to true, the provider issues an additional query so that metadata lists include a reliable "table" or "view" indicator for every object. This is useful for design tools, ORMs, or business intelligence platforms that need to distinguish tables from views automatically.

When this property is set to false, the provider skips the extra lookup, which can reduce metadata-fetch time on large schemas, but the object type field will be blank (or default) in metadata results.

This property is useful when you need to distinguish tables from views automatically. Enabling it prevents misclassification and saves manual filtering later.

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