Interface IRelQueryTableInfo

Namespace
ESRI.ArcGIS.Geodatabase
Assembly
ESRI.Server.Geodatabase.dll

Provides access to members that provide information about joins.

[InterfaceType(ComInterfaceType.InterfaceIsIUnknown)]
[Guid("D5A1B5BC-9A9F-4A40-BF34-69800D27EBE3")]
public interface IRelQueryTableInfo

Remarks

The IRelQueryTableInfo interface provides properties and methods that return information about a RelQueryTable after it has been created.

Properties

HasDirectAccessLookup

Indicates if direct access lookup is used by a RelQueryTable to match records between the source and destination tables.

bool HasDirectAccessLookup { get; }

Property Value

bool

Remarks

The HasDirectAccessLookup property returns true if the destination table supports the IRandomAccessCursor interface and the source table has an ObjectID field. This interface allows for faster data access and therefore better join performance. Tables from shapefile and ArcGIS for Desktop Advanced workspace factories support this interface.

JoinType

Type of table join.

esriJoinType JoinType { get; }

Property Value

esriJoinType

Remarks

The JoinType can be either esriLeftInnerJoin or esriLeftOuterJoin. A left outer join ensures that all records in the source are returned. A left inner join will only return rows that have matching key field values. The diagram below illustrates the difference.

 

When using ArcMap's user interface to join data, you can choose between either type of join. Clicking the advanced button on the join data dialog box will display a dialog box that allows you to choose the join type. Here, the "Keep all records" option refers to a left outer join when the "Keep only matching records" option specifies a left inner join.

 

QueryDef

QueryDef used to create the join. This property will be null if the join is done on the client.

IQueryDef QueryDef { get; }

Property Value

IQueryDef

Remarks

The QueryDef property returns the query that is used to retrieve the joined data when processing is done on the server. If the join is processed on the client as apposed to a server, the QueryDef property returns a null value.

If all tables involved are stored on the same ArcSDE, Personal or File Geodatabase, the processing can be performed by the server, which is normally faster. The JoinType must also be esriLeftInnerJoin in order for processing to occur on the server. In any other case, processing occurs on the client.

Methods

GetBaseTableOfField(string)

Returns the base table for a particular field.

ITable GetBaseTableOfField(string column)

Parameters

column string

Returns

ITable

Remarks

The GetBaseTableofField method will return the underlying Table object that is associated with a field in a RelQueryTable. To ensure that the column will be found, provide a fully qualified field name when executing this method.