Database Administrator Guide > Database Administrator Guide > A. System Catalogs > Vision System Catalogs > ii_vqjoins Catalog
Was this helpful?
ii_vqjoins Catalog
The ii_vqjoins catalog describes the joins involved in a visual query:
Column Name
Data Type
Description
object_id
integer
Object ID of the frame.
vq_seq
smallint
Sequence number (for ordering).
join_type
smallint
Type of join specified by this row.
0 = Master/Detail join.
1 = Master/Lookup join.
2 = Detail/Lookup join.
join_tab1
smallint
Index to table 1 of the join. Relative table number in visual query beginning with 0.
join_tab2
smallint
Index to table 2 of the join. Relative table number in visual query beginning with 0. (table 2 is always below table 1 in visual query).
join_col1
smallint
Join column for table 1. Index into array of columns for table 1. (Same as ii_vqtabcols.vq_seq).
join_col2
smallint
Join column for table 2. Index into array of columns for table 2. (Same as ii_vqtabcols.vq_seq).
Last modified date: 01/30/2023