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!
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
精彩评论