SELECT a.ownerid, a.cno, a.colname, a.colno
from sys.exu7ccl a, sys.con$ b , sys.cdef$ c
WHERE b.owner#=UID
AND b.con# = c.con#
AND c.rcon# = a.cno
View Text - HTML Formatted
SELECT A.OWNERID , A.CNO , A.COLNAME , A.COLNO
FROM SYS.EXU7CCL A , SYS.CON$ B , SYS.CDEF$ C
WHERE B.OWNER#=UID
AND B.CON# = C.CON#
AND C.RCON# = A.CNO