# Interface: MultiColumnExistsDefinition

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:59

Describes a correlated subquery that renders an EXISTS/NOT EXISTS predicate.

Extends

• ExistsSubqueryDefinition

Properties

on

on: string[]

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:60

---

sql

sql: string

Defined in: packages/core/src/transformers/ExistsPredicateInjector.ts:42

SQL that references the $c# placeholders for the anchor columns.

Inherited from

ExistsSubqueryDefinition.sql

---

params?

optional params: Record<string, SqlParameterValue&gt;

Defined in: packages/core/src/transformers/ExistsPredicateInjector.ts:44

Optional named parameters that the subquery requires.

Inherited from

ExistsSubqueryDefinition.params