Was this helpful?
System Catalogs for All Databases
Following are the table names of DBMS System Catalogs for all databases. The information in these catalogs is accessed by selecting from the standard catalogs:
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.
Last modified date: 01/30/2023