skip to main content
SQL Engine parse tree methods for .NET : SQL pass-through and advanced query methods reference : damex_describeTableJoinInfo
 

damex_describeTableJoinInfo

This method retrieves the outer/inner join information for a join query. If no outer/inner join exists, a value of 0 is returned for phJoinExp.
void damex_describeTableJoinInfo(
int64 hTable,
out int piJoinType,
out int64 phJoinExp)
 
Table 223: Parameters for damex_describeTableJoinInfo 
Parameter
Type
Description
IN
 
 
hTable
int64
The table handle.
OUT
 
 
piJoinType
int
The type of the join:
SQL_JOIN_LEFT_OUTER – left outer join
SQL_JOIN_RIGHT_OUTER – right outer join
SQL_JOIN_FULL_OUTER – full outer join
SQL_JOIN_INNER – inner join
phJoinExp
int64
The handle to the join expression in the ON clause of the join. A NULL is returned if no outer/inner join exists.