

Column name          Type                                    Nulls

tabname              char(18)                                yes
owner                char(8)                                 yes
dirpath              char(64)                                yes
tabid                serial                                  yes
rowsize              smallint                                yes
ncols                smallint                                yes
nindexes             smallint                                yes
nrows                integer                                 yes
created              date                                    yes
version              integer                                 yes
tabtype              char(1)                                 yes
audpath              char(64)                                yes


Index name	    Owner     Type    Cluster  Columns

tabname             informix  unique  No       tabname            
                                               owner              

tabid               informix  unique  No       tabid              


Column name          Type                                    Nulls

colname              char(18)                                yes
tabid                integer                                 yes
colno                smallint                                yes
coltype              smallint                                yes
collength            smallint                                yes


Index name	    Owner     Type    Cluster  Columns

column              informix  unique  Yes      tabid              
                                               colno              


Column name          Type                                    Nulls

idxname              char(18)                                yes
owner                char(8)                                 yes
tabid                integer                                 yes
idxtype              char(1)                                 yes
clustered            char(1)                                 yes
part1                smallint                                yes
part2                smallint                                yes
part3                smallint                                yes
part4                smallint                                yes
part5                smallint                                yes
part6                smallint                                yes
part7                smallint                                yes
part8                smallint                                yes


Index name	    Owner     Type    Cluster  Columns

idxtab              informix  dupls   No       tabid              

idxname             informix  unique  No       idxname            
                                               tabid              


Column name          Type                                    Nulls

username             char(8)                                 yes
usertype             char(1)                                 yes
priority             smallint                                yes
password             char(8)                                 yes


Index name	    Owner     Type    Cluster  Columns

users               informix  unique  No       username           


Column name          Type                                    Nulls

grantor              char(8)                                 yes
grantee              char(8)                                 yes
tabid                integer                                 yes
colno                smallint                                yes
colauth              char(3)                                 yes


Index name	    Owner     Type    Cluster  Columns

colgtor             informix  unique  No       tabid              
                                               grantor            
                                               grantee            
                                               colno              

colgtee             informix  dupls   No       tabid              
                                               grantee            


Column name          Type                                    Nulls

owner                char(8)                                 yes
synname              char(18)                                yes
created              date                                    yes
tabid                integer                                 yes


Index name	    Owner     Type    Cluster  Columns

synonym             informix  unique  No       owner              
                                               synname            

syntabid            informix  dupls   No       tabid              


Column name          Type                                    Nulls

btabid               integer                                 yes
btype                char(1)                                 yes
dtabid               integer                                 yes
dtype                char(1)                                 yes


Index name	    Owner     Type    Cluster  Columns

btabid              informix  dupls   No       btabid             

dtabid              informix  dupls   No       dtabid             


Column name          Type                                    Nulls

objtype              char(1)                                 yes
owner                char(8)                                 yes
name                 char(18)                                yes
tabid                integer                                 yes
state                char(1)                                 yes


Index name	    Owner     Type    Cluster  Columns

objdesc             informix  unique  No       objtype            
                                               name               
                                               owner              
                                               tabid              

objtab              informix  dupls   No       tabid              


Column name          Type                                    Nulls

grantor              char(8)                                 yes
grantee              char(8)                                 yes
tabid                integer                                 yes
tabauth              char(8)                                 yes


Index name	    Owner     Type    Cluster  Columns

tabgtor             informix  unique  No       tabid              
                                               grantor            
                                               grantee            

tabgtee             informix  dupls   No       tabid              
                                               grantee            


Column name          Type                                    Nulls

tabid                integer                                 yes
seqno                smallint                                yes
viewtext             char(64)                                yes


Index name	    Owner     Type    Cluster  Columns

view                informix  unique  No       tabid              
                                               seqno              
