But I need only one colname, owner, idxname, idxtype, tabname this 5 column information, can I compare food don't know how to lay their hands on the realization of
Great god grant instruction! Genuflect is begged!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Select sc colname, si. The owner, si. Idxname, si, clustered, si. Idxtype, st. tabname, st. owner, sc. Colno, ABS (si. Part1), ABS (si. Part2), ABS (si) part3), ABS (si) part4),
ABS (si. Part5), ABS (si. Part6), ABS (si) part7), ABS (si) part8), ABS (si) part9), ABS (si) part10), ABS (si) part11), ABS (si) part12), ABS (si) part13), ABS (si) part14), ABS (si) part15), ABS (si) part16)
The from test01: informix systables st, test01: informix. Sysindexes si, test01: informix. Syscolumns sc where
(st. tabname like 'aaa' or st. tabname like 'aaa') and st. tabid.=si tabid and sc. Tabid=st. tabid and st. owner like '%' and (sc) colno=ABS (si. Part1) or
Sc. Colno=ABS (si. Part2) or sc. Colno=ABS (si) part3) or sc. Colno=ABS (si) part4) or sc. Colno=ABS (si. Part5) or sc. Colno=ABS (si. Part6) or
Sc. Colno=ABS (si) part7) or sc. Colno=ABS (si) part8) or sc. Colno=ABS (si) part9) or sc. Colno=ABS (si) part10) or sc. Colno=ABS (si) part11) or
Sc. Colno=ABS (si) part12) or sc. Colno=ABS (si) part13) or sc. Colno=ABS (si) part14) or sc. Colno=ABS (si) part15) or
Sc. Colno=ABS (si) part16)) union
Select sc colname, si. The owner, si. Idxname, si, clustered, si. Idxtype, st. tabname, st. owner, sc. Colno, ABS (0), ABS (0), ABS (0),
ABS (0), ABS (0), ABS (0), ABS (0), ABS (0), ABS (0), ABS (0), ABS (0), ABS (0), ABS (0), ABS (0), ABS (0), ABS (0) from
Test01: informix systables st, test01: informix. Sysindices si, test01: informix. Syscolumns sc where
(st. tabname like 'aaa' or st. tabname like 'aaa') and (st. tabid.=si tabid and sc. Tabid=st. tabid and st. owner like '%')
And sc. Extended_id in (select extended_id from test01: informix. Sysxtdtypes) order by si. Idxname
CodePudding user response:
Their top first! D=====(￣ del ￣ *) b, the great god help!!!!!!!!!!!CodePudding user response:
Test01 dbschema cannot - d - t all - ss