开发者

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!


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
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜