DBA Data[Home] [Help]

VIEW: SYS.KU$_TTS_TABPARTVIEW

Source

View Text - Preformatted

SELECT tp.bo#, value(po), ts.name, ts.ts#
    FROM  sys.ku$_schemaobj_view po, sys.tabpart$ tp, sys.ts$ ts
    WHERE  po.obj_num = tp.obj# and
           tp.ts# = ts.ts#
View Text - HTML Formatted

SELECT TP.BO#
, VALUE(PO)
, TS.NAME
, TS.TS#
FROM SYS.KU$_SCHEMAOBJ_VIEW PO
, SYS.TABPART$ TP
, SYS.TS$ TS
WHERE PO.OBJ_NUM = TP.OBJ# AND TP.TS# = TS.TS#