DBPROP_SUBQUERIES

Property group: Data Source Information

Property set: DBPROPSET_DATASOURCEINFO

Type: VT_I4

Typical R/W: R

Description: Subquery Support

A bitmask specifying the predicates in text commands that support subqueries. A combination of zero or more of the following:

  • DBPROPVAL_SQ_CORRELATEDSUBQUERIES

  • DBPROPVAL_SQ_COMPARISON

  • DBPROPVAL_SQ_EXISTS

  • DBPROPVAL_SQ_IN

  • DBPROPVAL_SQ_QUANTIFIED

  • DBPROPVAL_SQ_TABLE

The DBPROPVAL_SQ_CORRELATEDSUBQUERIES bit indicates that all predicates that support subqueries support correlated subqueries.

The DBPROPVAL_SQ_TABLE bit indicates that subqueries are supported in place of tables (for example, in the FROM clause of an SQL statement).

Show: