Heterogeneous Table Support Property

ADO and SQL Server

ADO and SQL Server

Heterogeneous Table Support Property

The Heterogeneous Table Support property indicates whether the provider can join tables from different catalogs or providers.

Applies To
Connection Object
Syntax

object.Properties("Heterogeneous Table Support")

Parts

object

Expression that evaluates to an object in the Applies To list.

Returns

A bitmask containing zero or more of these settings.

Constant Description
DBPROPVAL_HT_DIFFERENT_CATALOGS Tables from different catalogs can be joined.
DBPROPVAL_HT_DIFFERENT_PROVIDERS Tables from different providers can be joined.

Data Type

adInteger

Modifiable

Read-only

OLE DB Property

DBPROP_HETEROGENEOUSTABLES