1;M;Tables/Views within Database;SELECT DISTINCT CREATOR FROM SYSADM.SYSTABLES;Schema;1500;
2;M;Synonyms within Database;SELECT DISTINCT CREATOR FROM SYSADM.SYSSYNONYMS;Schema;1200;
4;M;Triggers within Database;Select distinct creator from SYSADM.systriggers;Schema;1200;
5;M;Functions within;Select DISTINCT CREATOR from SYSADM.SYSEXTFUN;Schema;1500;
6;M;Indexes within Database;Select distinct CREATOR from SYSADM.SYSINDEXES;Schema;1200;
7;U;Users within Database;Select NAME from SYSADM.SYSUSERAUTH union select DISTINCT 'PUBLIC' from SYSADM.SYSUSERAUTH;User;1800;
10;M;Tables/Views within Schema;Select name, type, remarks from SYSADM.systables where creator= ? order by 1;Table;2500;Type;500;Desc;3500;
11;S;Full details of;Select * from SYSADM.systables where creator = ? and name = ?;Column;2000;Value;3000;
12;M;Indexes on;SELECT sys.CREATOR, sys.NAME, sys.UNIQUERULE,sys1.COLNAME, sys1.ORDERING FROM SYSSQL.SYSINDEXES sys, SYSSQL.SYSKEYS sys1 WHERE sys.NAME=sys1.IXNAME AND sys.CREATOR=sys1.IXCREATOR and TBCREATOR =? and tbname=? ORDER BY sys1.COLSEQ;Schema;1200;Index;1800;Type;500;Column;1800;Asc/Desc;900;
13;M;Primary Key for;Select COLNAME, PKCOLSEQNUM from SYSADM.SYSPKCONSTRAINTS WHERE CREATOR=? AND NAME=?;Column;1500;Seq;800;
14;M;Full details of;Select tbcreator, tbname from SYSADM.syssynonyms where creator = ? and name = ?;Creator;1500;Name;2000;
15;M;Access list for;Select distinct grantee, selectauth, updateauth, insertauth, deleteauth, alterauth from sysadm.systabauth where tcreator = ? and ttname=? order by grantee;Userid;1500;Select;800;Update;800;Insert;800;Del;800;Alter;600;
17;W;Definition of view;Select TEXT from SYSADM.SYSVIEWS WHERE CREATOR=? AND NAME=? ;View Text;5025;
18;M;Functions within schema;Select FUNCNAME,REMARKS, specificname from SYSADM.FUNCTIONS WHERE FUNCSCHEMA = ?;Name;1800;Desc;2500;Internal Name;1;
19;M1;Parameters for function;select TYPENAME, LENGTH, SCALE, ROWTYPE, CAST_FUNCID, PARMNAME From SYSADM.FUNCPARMS Where specificname = ? order by ordinal;Type;1500;Length;600;Scale;500;Row Type;900;Cast as;900;Desc;2000;
20;C;Column list for;SELECT NAME, COLTYPE, LENGTH, SCALE, NULLS, REMARKS,'', COLNO FROM SYSADM.SYSCOLUMNS WHERE tbCREATOR=? and TBNAME=? order by colno;Name;2000;Type;1200;Length;650;Scale;500;Nulls;500;Desc;3000;
25;S;Details of trigger;Select * from SYSADM.SYSTRIGGERS WHERE creator = ? and NAME =?;Column;2000;Value;3000;
29;S;Details of function;Select * from SYSADM.SYSEXFUN where creator=? and name = ?;Column;2000;Value;5000;
31;M;Synonyms within Schema;Select NAME, 'S' from SYSADM.SYSSYNONYMS where CREATOR =? order by 1;Table;2500;Type;1;
32;M;Packages within Schema;Select PKGNAME, valid, remarks, LAST_BIND_TIME,TOTAL_SECT from SYSADM.PACKAGES where pkgschema=? order by 1;Name;1500;Valid;500;Desc;2500;
33;M;Triggers within Schema;Select NAME from SYSADM.SYSTRIGGERS where creator=? order by 1;Name;2000;
34;D;Contents of;Select;Name;1500;
35;O;Referenced Tables for;D;Schema;1000;Table;1800;Cols(PK);2000;FK in Dep Tab;2000;
36;O;Dependent tables;F;Schema;1000;Table;1800;Cols(FK);2000;PK in Ref Tab;2000;
42;M;Indexes within Schema;Select NAME,TBNAME, TBCREATOR from SYSADM.SYSINDEXES WHERE CREATOR=?;Name;2000;Tab Name;2500;Tab Creator;1000;
43;S;Details of Index;Select * from SYSADM.SYSINDEXES WHERE CREATOR=? AND NAME=?;Column;2000;Value;3000;
44;M;Columns in Index;Select COLNAME ,ORDERING, COLSEQ from SYSADM.SYSKEYS WHERE IXCREATOR=? and IXNAME=? ORDER BY COLSEQ;Column;2500;Asc/Desc;900;Seq;800;
45;A;Table authorities for user;Select distinct tCREATOR, ttNAME,SELECTAUTH, UPDATEAUTH,INSERTAUTH, DELETEAUTH, ALTERAUTH from SYSADM.SYSTABAUTH WHERE GRANTEE=? ORDER BY 1,2;Schema;1500;Name;1800;Select;600;Update;600;Insert;600;Delete;600;Alter;600;Control;600;References;600;Index;600;
48;V;Definition of view;Select TEXT from SYSADM.SYSVIEWS WHERE CREATOR=? AND NAME=? ;a;2505;
49;M;Views within Schema;Select name, type, substr(remarks,1,50) from sysibm.systables where creator = ? and type = 'V' order by 1;View;2000;Type;1;Desc;3500;
51;W;Text of trigger;Select TEXT from SYSADM.SYSTRIGGERS WHERE creator = ? and NAME =?;Text;2000;
52;W1;Text of function;Select varchar(substr(BODY,1,2000)) from SYSADM.FUNCTIONS where specificname = ?;Text;5895;
55;F;Column list for Synonym;SELECT col.NAME, col.COLTYPE, col.LENGTH, col.SCALE, col.NULLS, col.REMARKS, '', col.COLNO FROM SYSADM.SYSCOLUMNS col, SYSADM.SYSSYNONYMS syn WHERE col.TBNAME=syn.TBNAME AND col.TBCREATOR=syn.TBCREATOR AND syn.CREATOR = ? AND syn.NAME = ? ORDER BY col.COLNO;Name;2000;Type;1200;Length;650;Scale;500;Nulls;500;Desc;3000;
73;Q;View as Query;Select TEXT from SYSADM.SYSVIEWS WHERE CREATOR=? AND NAME=? ;View Text;2505;