Heterogeneous Table Support Property
From 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