EnumReferencingTables List

SQLServer.Database.Table Object

Description

Lists the other tables that reference this Table. List is returned in a QueryResults object.

Visual Basic

QueryResults = Table.EnumReferencingTables ( [[IncludeAllCandidates :=] bIncludeCandidates] )

C++

HRESULT pTable->EnumReferencingTables (
LPSQLOLEQUERYRESULTS * ppQueryResults,
BOOL bIncludeCandidates = NULL );

Elements

Element Type Description

QueryResults QueryResults Returned QueryResults object
bIncludeCandidates Boolean Determines if all possible candidate tables are included in the list, even those not referenced. If True, candidate tables are included. If False, candidate tables are not included.

QueryResults

ColumnName ColumnType

candidate_table SQLOLE_DTypeChar
candidate_key SQLOLE_DTypeChar
referenced SQLOLE_DTypeBit

Remarks

The returned QueryResults contains a column indicating if a key is referenced.