ODBC Driver for SQL Server

Build 25.0.9434

IncludeTableTypes

Specifies whether to query SQL Server for the object types of individual tables and views.

Data Type

bool

Default Value

true

Remarks

When enabled, the driver queries SQL Server to identify whether each object is a table or a view. This can help tools and applications distinguish between different object types during schema discovery.

When disabled, the driver skips this check which may improve metadata retrieval performance, but results in all objects being treated generically without specific type metadata.

This property is useful when an application needs to differentiate between tables and views, such as for filtering or organizing metadata. Set this property to false to potentially improve performance during schema discovery, especially in environments with many objects.

This setting affects only schema metadata and does not impact the ability to query or interact with the actual data.

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