Informix 9.53C1 上有哪些默认系统表可用?

发布于 12-02 15:29 字数 851 浏览 3 评论 0原文

我正在寻找 Informix 9.53C1 系统表/目录的数据字典。

我发现几个网站显示了其中一些表,但我找不到所有系统表及其内容的完整、全面的列表。

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

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

我正在寻找所有Informix 内置的默认系统表。拥有所有这些表字段的列表也会有很大帮助,但只要我有表名称,我就可以自己去寻找它们的字段。

示例:

informix.systables 是所有表的详细列表

informix.syscolumns 是所有列的详细列表


Jonathan Leffler, help me again please!

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!

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

睫毛上残留的泪2024-12-09 15:29:10

看起来,至少这些表都是默认的系统表:

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

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
~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文