select '1','0',
k.xdsid#,
k.order#,
k.pkey, /* primary key (col name from master table) */
k.fkey, /* foreign key (col name or value in detail table */
k.fkey_type /* 1=fk is col name; 2=fk is col value */
from xs$instset_inh_key k
SELECT '1'
, '0'
,
K.XDSID#
,
K.ORDER#
,
K.PKEY
, /* PRIMARY KEY (COL NAME
FROM MASTER TABLE) */
K.FKEY
, /* FOREIGN KEY (COL NAME OR VALUE IN DETAIL TABLE */
K.FKEY_TYPE /* 1=FK IS COL NAME; 2=FK IS COL VALUE */
FROM XS$INSTSET_INH_KEY K
|
|
|