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.

iidevices

Describes additional locations when a user table spans more than one location.

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.

iicdbid_idx

Index on iistar_cdbs

iidatabase

Various attributes of the databases existing in this installation.

iidbid_idx

Index on iidatabase.

iidbpriv

Contains information about database privileges.

iidbdb_netcost

Contains costing information used by Ingres Star.

iidbdb_nodecost

Contains costing information used by Ingres Star.

iiextend

Information about what locations databases have been extended to.

iigw07_attribute

Ingres Management Architecture (IMA) catalog.

iigw07_index

Ingres Management Architecture (IMA) catalog.

iigw07_relation

Ingres Management Architecture (IMA) catalog.

iilocations

Storage locations defined in this installation.

iiprofile

User profiles defined in this installation.

iirole

Roles defined in this installation

iirolegrant

Information about which grantees have role privileges.

iisecuritystate

Information relating to the security state of this installation.

iistar_cdbs

Information about Ingres Star coordinator databases in this installation.

iiuser

Users defined in this installation

iiusergroup

Group definitions for this installation

iiocolumns

An old system catalog interface that has been replaced by iicolumns.

iiotables

An old system catalog interface that has been replaced by iitables.

iistar_cdbinfo

A standard catalog interface to data that describes coordinator databases for Ingres Star. For more information, see the Ingres Star User Guide.