VIEW: SYS.KU$_PFHTABPROP_VIEW

Source

View Text - Preformatted

select t.obj_num,t.name,t.schema,t.flags,t.property from ku$_tabprop_view t
 where bitand(t.property,32+64+128+256+512)=32
 and not exists( select * from partobj$ po
             where po.obj# = t.obj_num and po.parttype = 5)

View Text - HTML Formatted

SELECT T.OBJ_NUM
, T.NAME
, T.SCHEMA
, T.FLAGS
, T.PROPERTY
FROM KU$_TABPROP_VIEW T
WHERE BITAND(T.PROPERTY
, 32+64+128+256+512)=32
AND NOT EXISTS( SELECT *
FROM PARTOBJ$ PO
WHERE PO.OBJ# = T.OBJ_NUM
AND PO.PARTTYPE = 5)