Search code examples
databaseschemainformixcatalogdata-dictionary

What default system tables are available on Informix 9.53C1?


I'm looking for the data dictionary for Informix 9.53C1 system tables/catalog.

I've found a couple sites that show some of these tables, but I couldn't find a full, comprehensive list of all system tables and their contents.

http://download.oracle.com/docs/html/B10528_01/apc.htm#634419

http://www.ibm.com/developerworks/data/zones/informix/library/techarticle/0305parker/0305parker.html

I'm looking for a list of all the the default system tables built into Informix. Having a list of all these tables' fields would also help greatly, but as long as I have the table names, I can go fishing for their fields myself.

Example:

informix.systables is a detailed listing of all tables

informix.syscolumns is a detailed listing of all columns


Jonathan Leffler, help me again please!


Solution

  • It seems that, at the very least, these tables are all default system tables:

    sysaggregates
    sysams
    sysattrtypes
    sysblobs
    syscasts
    syschecks
    syscolattr
    syscolattribs
    syscolauth
    syscoldepend
    syscolperm
    syscolumns
    sysconstraints
    sysdefaults
    sysdepend
    sysdirectives
    sysdistrib
    sysdomains
    syserrors
    sysextcols
    sysextdfiles
    sysexternal
    sysfragauth
    sysfragments
    sysindexes
    sysindices
    sysinherits
    syslangauth
    syslogmap
    sysobjstate
    sysopclasses
    sysopclstr
    sysprocauth
    sysprocbody
    sysproccolumns
    sysprocedures
    sysprocperm
    sysprocplan
    sysreferences
    sysroleauth
    sysroutinelangs
    sysseclabelauth
    sysseclabelcomponentelements
    sysseclabelcomponents
    sysseclabelnames
    sysseclabels
    syssecpolicies
    syssecpolicycomponents
    syssecpolicyexemptions
    syssequences
    syssurrogateauth
    syssynonyms
    systabamdata
    systabauth
    systables
    systabperm
    systraceclasses
    systracemsgs
    systrigbody
    systriggers
    sysusers
    sysviews
    sysviolations
    sysxadatasources
    sysxasourcetypes
    sysxtddesc
    sysxtdtypeauth
    sysxtdtypes