Catalog | Description |
iiattribute | Describes the properties of each column of a table. |
iidbdepends | Describes the dependencies between views or protections and their base tables. |
iidbms_comment | Contains text for comments on tables or columns. |
iidefault | Stores default values used by any attribute (column) in any table residing in this database. |
iidistcol | Lists the partitioning columns for partitioned tables. |
iidistscheme | Contains information about partitioning schemes for partitioned tables. |
iidistval | Contains the partitioning values and directives for LIST or RANGE partitioned tables. |
iievent | Contains database event information. |
iiextended_relation | Contains information about the association between base tables and the extended tables used to store long data types. |
iigw06_attribute | Security audit gateway catalogs. |
iigw06_relation | Security audit gateway catalogs. |
iihistogram | Contains database histograms that are collected by the optimizedb program. |
iiindex | Describes all the indexes for a table. |
iiintegrity | Contains information about the integrities applied to tables. |
iikey | Contains information about key attributes for unique and referential constraints. |
iipartname | Contains logical partition names for partitioned tables. |
iipriv | Contains information about privileges and their dependent objects. |
iiprivlist | Contains list of privilege names. |
iiprocedure | Contains information about database procedures. |
iiprocedure_ parameter | Contains information about database procedure parameters. |
iiprotect | Contains information about the protections applied to tables. |
iiqrytext | Contains the actual query text for views, protections, and integrities. |
iirel_idx | An index table that indexes the iirelation table by table name and owner. |
iirelation | Describes each table in the database. |
iirule | Contains information about rules in the database. |
iischema | Contains the schema name, owner and ID. |
iisecalarm | Contains information about security alarms. |
iisectype | A lookup table for security event types. |
iisequence | Contains information about all sequences defined in the database. |
iistatistics | Contains database statistics that are collected by the optimizedb program. |
iisynonym | Contains information on the synonyms that have been defined for tables, views and indexes. |
iitree | Contains the DBMS internal representation of query text for views, protections, and integrities. |
iixdbdepends | An index table used to find the rows that reference a dependent object in the iidbdepends catalog. |