Appendix B. Data Dictionary Tables

HiRDB creates and manages the data dictionary tables that store table, index, and other types of definition information. Data manipulation SQL statements are used to reference data dictionary tables in order to check and confirm table, index, and other types of definition information.

The following table lists the HiRDB data dictionary tables. For examples of SQL coding for referencing data dictionary tables and columns in the data dictionary tables, see the HiRDB Version 9 UAP Development Guide.

Table B-1 Data dictionary tables

No.Table nameContentsInformation coverage (per row)
1SQL_PHYSICAL_FILESHiRDB file information (correspondence between HiRDB file system name and RDAREA names)One HiRDB file
2SQL_RDAREASInformation such as RDAREA name, definition information, RDAREA type, number of tables stored, and number of indexesOne RDAREA
3SQL_TABLESOwner and table names of tables in a database (including dictionary tables)One table
4SQL_COLUMNSDefinition information related to a column, such as column name and data typeOne column
5SQL_INDEXESOwner and index names of indexes in a database (including dictionary tables)One index
6SQL_USERSAuthorization identifier of the user who granted a user execution privilege and database accessOne user
7SQL_RDAREA_PRIVILEGESRDAREA usage privilege statusOne RDAREA of One authorization identifier
8SQL_TABLE_PRIVILEGESTable access privilege granting statusOne table of 1 authorization identifier
9SQL_VIEW_TABLE_USAGEName of base table on which a view table is basedOne view table
10SQL_VIEWSView definition informationOne view table
11SQL_DIV_TABLETable division information (division condition and name of RDAREA for storage, as specified in CREATE TABLE)One table per n rows
12SQL_INDEX_COLINFName of column to which an index is assignedOne index per n rows
13SQL_DIV_INDEXIndex division information (name of RDAREA for storage)One index per n rows
14SQL_DIV_COLUMNBLOB type column division information (name of RDAREA for storage, as specified in CREATE TABLE)One column per n rows
15SQL_ROUTINESRoutine definition informationOne routine per row
16SQL_ROUTINE_RESOURCESInformation on resources used in a routineOne routine per n rows
17SQL_ROUTINE_PARAMSParameter definition information in a routineOne routine per n rows
18SQL_TABLE_STATISTICSTable statistical informationOne table
19SQL_COLUMN_STATISTICSColumn statistical informationOne column
20SQL_INDEX_STATISTICSIndex statistical informationOne index
21SQL_DATATYPESUser-defined type informationOne user-defined type
22SQL_DATATYPE_DESCRIPTORSInformation on an attribute that comprises a user-defined typeOne attribute
23SQL_TABLE_RESOURCESResource information to be used in a tableOne resource
24SQL_PLUGINSPlug-in informationOne plug-in
25SQL_PLUGIN_ROUTINESPlug-in routine informationOne plug-in routine
26SQL_PLUGIN_ROUTINE_PARAMSParameter information of a plug-in routineOne parameter information item
27SQL_INDEX_TYPESIndex type informationOne index type
28SQL_INDEX_RESOURCESResource information to be used for an indexOne resource information item
29SQL_INDEX_DATATYPEIndex item informationOne applicable information item (one step)
30SQL_INDEX_FUNCTIONInformation on an abstract data type facility to be used for an indexInformation on One abstract data type facility
31SQL_TYPE_RESOURCESResource information to be used in a user-defined typeOne resource information item
32SQL_INDEX_TYPE_FUNCTIONInformation on an abstract data type facility that can be used by an index for which index type has been definedOne index per n rows
33SQL_EXCEPTInformation on index exception key valuesException key group of one index per n rows
34SQL_IOS_GENERATIONSUNIX edition:
Generation information on the HiRDB file system areas when the inner replica facility is being used
Windows edition:
Information used by the system (containing no data)
UNIX edition:
1 HiRDB file system area per row
Windows edition:
None
35SQL_TRIGGERSTrigger information in schemasOne trigger per row
36SQL_TRIGGER_COLUMNSEvent column list information on UPDATE triggersOne event column data item per row
37SQL_TRIGGER_DEF_SOURCEDefinition source information on triggersOne trigger definition source data item per n rows
38SQL_TRIGGER_USAGEResource information referenced by trigger action conditionsOne resource name referenced by the trigger action condition per row
39SQL_PARTKEYInformation on partitioning keys of matrix-partitioned tablesOne partitioning key data item per row
40SQL_PARTKEY_DIVISIONInformation on partitioning condition values of matrix-partitioned tablesOne partitioning condition value data item per row
41SQL_AUDITSInformation on audit targetsOne event data item for an object or one user per row
42SQL_REFERENTIAL_CONSTRAINTSMatch state of referential constraintsOne constraint per row
43SQL_KEYCOLUMN_USAGEInformation on columns comprising foreign keysOne column per row
44SQL_TABLE_CONSTRAINTSInformation on integrity constraints in schemasOne integrity constraint per row
45SQL_CHECKSInformation on check constraintsOne check constraint per row
46SQL_CHECK_COLUMNSInformation on columns used by check constraintsOne column used by a check constraint per row
47SQL_DIV_TYPEPartitioning key information on partitioning keys in matrix-partitioned tables, combining key range partitioning and hash partitioningOne partitioning key per row
48SQL_SYSPARAMSInformation on the number of consecutive certification failures permitted and on password character string restrictionsOne setting item per row, or one permitted number of consecutive certification failure specifications, or one password character string restriction specification per n rows
49SQL_INDEX_XMLINFInformation on the substructure path comprising the index of substructure indexesOne index per row
50SQL_SEQUENCESSequence generator informationData on one sequence generator per row