select c.obj#,
c.col#,
c.intcol#,
c.segcol#,
bitand(c.property, 4294967295),
trunc(c.property / power(2,32)),
c.name,
(select a.name from attrcol$ a where
a.obj#=c.obj# and a.intcol#=c.intcol#),
c.type#,
c.deflength, '', '', null
from col$ c, col$ cc, tab$ t
where c.obj# = t.obj#
and cc.obj# = t.bobj#
and cc.segcol# = c.segcol#
SELECT C.OBJ#
,
C.COL#
,
C.INTCOL#
,
C.SEGCOL#
,
BITAND(C.PROPERTY
, 4294967295)
,
TRUNC(C.PROPERTY / POWER(2
, 32))
,
C.NAME
,
(SELECT A.NAME
FROM ATTRCOL$ A WHERE
A.OBJ#=C.OBJ#
AND A.INTCOL#=C.INTCOL#)
,
C.TYPE#
,
C.DEFLENGTH
, ''
, ''
, NULL
FROM COL$ C
, COL$ CC
, TAB$ T
WHERE C.OBJ# = T.OBJ#
AND CC.OBJ# = T.BOBJ#
AND CC.SEGCOL# = C.SEGCOL#
|
|
|