1;M;Tables/Views within Database;Select DISTINCT OWNER from INFORMIX.SYSTABLES where tabtype <> '';Owner;1500;
2;M;Tables (only) within Database;Select DISTINCT OWNER from INFORMIX.SYSTABLES where tabtype = 'T';Owner;1200;
4;M;Triggers within Database;Select DISTINCT OWNER from INFORMIX.SYSTRIGGERS order by 1;Owner;1200;
5;M;DBSpaces within Database;Select name,dbsnum from sysmaster:informix.sysdbspaces;Owner;1065;ID;1;
6;M;Indexes within Database;Select DISTINCT OWNER from INFORMIX.SYSINDEXES;Owner;1200;
7;U;Users within Database;Select USERNAME, case usertype when 'D' then 'DBA' when 'C' then 'Connect' when 'R' then 'Resource' end from INFORMIX.SYSUSERS;User;1200;Authority;1200;
9;M;Views within Database;Select DISTINCT OWNER from INFORMIX.SYSTABLES where tabtype = 'V';Owner;1200;
10;M;Tables/Views within Owner;Select TABNAME ,TABTYPE, TABID from INFORMIX.SYSTABLES WHERE OWNER =? and tabtype <> '' order by 1;Table;1980;Type;500;Id;1;
11;S;Full details of;Select * from INFORMIX.SYSTABLES WHERE OWNER =? AND TABNAME =?;Column;750;Value;1110;
12;M1;Indexes on;Select OWNER ,IDXNAME ,IDXTYPE, clustered, PART1, PART2, PART3, PART4 from INFORMIX.SYSINDEXES WHERE TABID =? order by 1,2;Owner;600;Index;510;Type;500;Clustered;800;Col1;405;Col2;405;Col3;405;Col4;405;
13;M;Tables/Views within Owner;Select TABNAME ,TABTYPE, TABID from INFORMIX.SYSTABLES WHERE OWNER =? and tabtype <> '' order by 1;Table;2500;Type;500;Id;500;
15;M1;Access list for;Select distinct GRANTEE ,TABAUTH from INFORMIX.SYSTABAUTH WHERE TABID =? order by grantee;Userid;780;Authority;735;
17;W1;Definition of view;Select VIEWTEXT,seqno from INFORMIX.SYSVIEWS where TABID =? ORDER BY SEQNO;View Text;5475;
20;C;Column list for;O;Name;1170;Type;1000;Length;645;Scale;500;Nulls;500;
21;M1;Check Constraints for;SELECT c.COLNAME, n.CONSTRNAME, k.CHECKTEXT, k.seqno FROM INFORMIX.SYSCOLDEPEND d, INFORMIX.SYSCOLUMNS c, INFORMIX.SYSCONSTRAINTS n, INFORMIX.SYSCHECKS k WHERE d.TABID=c.TABID AND d.COLNO=c.COLNO AND d.CONSTRID=n.CONSTRID AND d.CONSTRID=k.CONSTRID AND d.TABID =? AND n.CONSTRTYPE = 'C' AND k.TYPE = 'T' ORDER BY k.SEQNO;Column;630;Constraint;840;Text;405;
22;Q1;View as Query;Select VIEWTEXT,seqno from INFORMIX.SYSVIEWS where TABID =? ORDER BY SEQNO;View Text;2505;
23;M1;Title;SELECT tab1.owner, tab1.tabname, tab1.tabid FROM informix. systables tab1, informix.sysdepend dep WHERE tab1.tabid=dep.btabid and dep.dtabid=? and dep.dtype='V';Creator;900;Name;1095;Tabid;1;
24;M1;Title;SELECT tab1.owner, tab1.tabname, tab1.tabid FROM informix. systables tab1, informix.sysdepend dep WHERE tab1.tabid=dep.dtabid and dep.btabid=? and dep.dtype='V';Creator;900;Name;1635;Tabid;1;
25;T;Details of trigger;Select * from INFORMIX.SYSTRIGGERS WHERE OWNER =? AND TRIGNAME=?;Column;720;Value;735;
26;M1;Triggers on table;Select OWNER ,TRIGNAME ,EVENT ,TRIGID from INFORMIX.SYSTRIGGERS WHERE TABID =?;Owner;600;Name;540;Event;540;id;1;
27;W1;Details of trigger;Select data, seqno,datakey from INFORMIX.SYSTRIGBODY WHERE trigid = ? and datakey in ('D','A') order by seqno, datakey desc;Text;3000;
28;O;Primary Key for;P;Column;690;
29;O;Referenced Tables for;D;Schema;705;Table;525;Cols(PK);720;FK in Dep Tab;1245;
30;O;Dependent tables;F;Schema;705;Table;525;Cols(FK);705;PK in Ref Tab;1200;
31;M;Tables (only) within Owner;Select TABNAME, 'T', TABID from INFORMIX.SYSTABLES WHERE tabtype = 'T' and OWNER =? order by 1;Table;1920;Type;1;Id;1;
32;M;Tables Sizing for ;Select tabname, nrows, rowsize, ncols, nindexes,tabid from informix.systables order by 2 desc;Table;2000;Rows;1000;Row Size;1000;Columns;1000;Indexes;1000;Id;1;
33;M;Triggers within Owner;Select TRIGNAME, trigid from INFORMIX.SYSTRIGGERS WHERE OWNER =? ORDER BY 1;Name;1005;Trigid;1;
35;S1;Details of DBSpace;Select * from sysmaster:informix.sysdbspaces WHERE dbsnum =?;Column;1140;Value;630;
36;M1;Chunks within DB Space;Select chknum, flags, fname, mfname from sysmaster:informix.syschunks WHERE dbsnum =?;Chunk;600;Flags;495;Fille Name;3600;Mirror File;3780;
42;M;Indexes within Owner;SELECT sys.IDXNAME, sys.IDXTYPE, sys1.OWNER, sys1.TABNAME FROM INFORMIX.SYSINDEXES sys, INFORMIX.SYSTABLES sys1 WHERE sys.TABID=sys1.TABID AND sys.OWNER = ? order by 1;Name;1260;Type;465;Tab Owner;1000;Tab Name;1230;
43;S;Details of Index;Select * from INFORMIX.SYSINDEXES WHERE OWNER=? AND IDXNAME=?;Column;1500;Value;3000;
45;M;Access list for;SELECT distinct t.owner, t.tabname FROM informix.systabauth a, informix.systables t WHERE a.tabid=t.tabid AND a.grantee = ? order by 1,2;Creator;1200;Table;2000;
48;V1;Definition of view;Select VIEWTEXT,seqno from INFORMIX.SYSVIEWS where TABID =? ORDER BY SEQNO;a;2790;
49;M;Views within Owner;Select TABNAME, 'V', TABID from INFORMIX.SYSTABLES WHERE tabtype = 'V' and OWNER =? order by 1;View;2000;Type;1;Id;1;
50;M;Access list (with grantor) for;SELECT distinct t.owner, t.tabname,a.grantor FROM informix.systabauth a, informix.systables t WHERE a.tabid=t.tabid AND a.grantee = ? order by 1,2;Creator;1200;Table;2000;Grantor;1200;
51;M;Procedure Authorities for;SELECT distinct p.owner, p.procname,a.grantor FROM informix.sysprocauth a, informix.sysprocedures p WHERE a.procid=p.procid AND a.grantee = ? order by 1,2;Creator;1200;Procedure;2000;Grantor;1200;
68;M;Procedures within database;Select DISTINCT OWNER from INFORMIX.SYSPROCEDURES;Owner;1500;
69;M;Procedures within Owner;Select PROCNAME , NUMARGS, PROCID from INFORMIX.SYSPROCEDURES WHERE OWNER =? order by 1;Name;2000;Num Parms;1000;Procid;1;
70;T;Details of procedure;Select * from INFORMIX.SYSPROCEDURES WHERE OWNER =? AND PROCNAME =?;Column;840;Value;630;
71;O;Parameters for Procedure;B;Name;2000;Parm Type;1000;Data Type;1000;Nulls;800;
72;M1;Access list for;Select distinct grantee, procauth from INFORMIX.SYSPROCAUTH WHERE procid=? order by grantee;Userid;780;Authority;735;
73;W1;Text for Procedure;SELECT data,seqno FROM informix.sysprocbody where procid=? and datakey = 'T' ORDER BY 2;Text;2000;
74;M;Procedures within Owner;Select PROCNAME , PROCID from INFORMIX.SYSPROCEDURES WHERE OWNER =? order by 1;Name;2000;Procid;800;