VIEW: SYS.KU$_TTS_TABVIEW

Source

View Text - Preformatted

SELECT t.obj#, value(o), ts.name, ts.ts#
    FROM  sys.ku$_schemaobj_view o, sys.tab$ t, sys.ts$ ts
    WHERE  (BITAND (t.property,32)!=32) and
           o.obj_num = t.obj# and
           t.ts# = ts.ts#
  UNION ALL
    SELECT t.obj#, value(o), ts.name, ts.ts#
    FROM  sys.ku$_schemaobj_view o, sys.tab$ t,
          sys.lobfrag$ lf, sys.ts$ ts
    WHERE  (BITAND (t.property,32)!=32) and
           o.obj_num = t.obj# and
           lf.tabfragobj# = t.obj# and
           lf.ts# = ts.ts#

View Text - HTML Formatted

SELECT T.OBJ#
, VALUE(O)
, TS.NAME
, TS.TS#
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.TAB$ T
, SYS.TS$ TS
WHERE (BITAND (T.PROPERTY
, 32)!=32) AND O.OBJ_NUM = T.OBJ# AND T.TS# = TS.TS# UNION ALL SELECT T.OBJ#
, VALUE(O)
, TS.NAME
, TS.TS#
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.TAB$ T
, SYS.LOBFRAG$ LF
, SYS.TS$ TS
WHERE (BITAND (T.PROPERTY
, 32)!=32) AND O.OBJ_NUM = T.OBJ# AND LF.TABFRAGOBJ# = T.OBJ# AND LF.TS# = TS.TS#