DBA Data[Home] [Help]

VIEW: SYS.KU$_XSINST_INHKEY_VIEW

Source

View Text - Preformatted

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
View Text - HTML Formatted

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