informix-系统视图

/****************************************************************************/
informix 系统视图
/****************************************************************************/
1 systables
2 sysviews
3 sysindexes
4 syscolumns
5 sysconstraints
6 sysreferences
7 sysfragments
8 syssequences
9 sysprocedures
10 sysprocbody
11 systriggers
12 systrigbody


1 tabid,tabtype 
tabtype:
T = Table
v E = External Table
v V = View
v Q = Sequence
v P = Private synonym
v S = Public synonym
> select tabid,tabtype from systables where tabname='p$kpi_t_roletodept';
     tabid tabtype 


        934 T


1 row(s) retrieved.


2 viewtext
> select viewtext from sysviews where tabid=71 order by seqno;
viewtext  create view "informix".sysindexes (idxname,owner,tabid,idxtype,cluste
          red,part1,part2,part3,part4,part5,part6,part7,part8,part9,part10,part
          11,part12,part13,part14,part15,part16,levels,leaves,nunique,clust) as
           select x0.idxname ,x0.owner ,x0.tabid ,x0.idxtyp


viewtext  e ,x0.clustered ,ikeyextractcolno(x0.indexkeys ,0 ),ikeyextractcolno(
          x0.indexkeys ,1 ),ikeyextractcolno(x0.indexkeys ,2 ),ikeyextractcolno
          (x0.indexkeys ,3 ),ikeyextractcolno(x0.indexkeys ,4 ),ikeyextractcoln
          o(x0.indexkeys ,5 ),ikeyextractcolno(x0.indexkeys


viewtext   ,6 ),ikeyextractcolno(x0.indexkeys ,7 ),ikeyextractcolno(x0.indexkey
          s ,8 ),ikeyextractcolno(x0.indexkeys ,9 ),ikeyextractcolno(x0.indexke
          ys ,10 ),ikeyextractcolno(x0.indexkeys ,11 ),ikeyextractcolno(x0.inde
          xkeys ,12 ),ikeyextractcolno(x0.indexkeys ,13 ),i


viewtext  keyextractcolno(x0.indexkeys ,14 ),ikeyextractcolno(x0.indexkeys ,15 
          ),x0.levels ,x0.leaves ,x0.nunique ,x0.clust from "informix".sysindic