Appendix F. Data Dictionary Table Retrieval

HiRDB data dictionary tables can be referenced in the same way as an ordinary HiRDB database by using operation SQL statements. The authorization identifier of a dictionary table is MASTER.

This appendix provides examples of SQL descriptions for dictionary table retrievals and explains the definition information required for referencing.

Table F-1 lists the data dictionary tables that can be referenced.

Table F-1 Data dictionaries

NumberTable nameDescriptionRow contents
1SQL_PHYSICAL_FILESHiRDB file information (correspondences between HiRDB file system names and RDAREA names)One HiRDB file
2SQL_RDAREASInformation such as the RDAREA names, their definition information, the RDAREA types, the number of stored tables, and number of indexesOne RDAREA
3SQL_TABLESOwner name and table name of each table (including dictionary tables) in the databaseOne table
4SQL_COLUMNSColumn definition information, such as the column names and their data typesOne column
5SQL_INDEXESOwner name and index name of each index (including dictionary tables) in the databaseOne index
6SQL_USERSExecution privileges and authorization identifiers of users authorized to access the databaseOne user
7SQL_RDAREA_PRIVILEGESGrants of RDAREA usage privilegesUse of one RDAREA for one authorization identifier
8SQL_TABLE_PRIVILEGESGrants of table access privilegesAccess to one table for one authorization identifier
9SQL_VIEW_TABLE_USAGENames of base tables used for view tablesOne view table
10SQL_VIEWSView definition informationOne view table
11SQL_DIV_TABLETable partitioning information (partitioning conditions specified in CREATE TABLE and names of RDAREAs that store partitioned tables)One table (described by n rows)
12SQL_INDEX_COLINFNames of columns to which indexes are assignedOne index (described by n rows)
13SQL_DIV_INDEXIndex partitioning information (storage RDAREA names)One index (described by n rows)
14SQL_DIV_COLUMNBLOB-type column partitioning information (storage RDAREA names specified when CREATE TABLE was executed)One column (described by n rows)
15SQL_ROUTINESRoutine definition informationOne routine (described by one row)
16SQL_ROUTINE_RESOURCESInformation about resources used in a routineOne routine (described by n rows)
17SQL_ROUTINE_PARAMSInformation about parameter definitions in a routineOne routine (described by n rows)
18SQL_ALIASESFor UNIX:
Alias information about tables (table aliases specified when CREATE ALIAS was executed and the three-part name of the target table)
For Windows:
Used by the system (table is empty)
For UNIX:
One alias
For Windows:
None
19SQL_TABLE_STATISTICSTable statistical informationOne table
20SQL_COLUMN_STATISTICSColumn statistical informationOne column
21SQL_INDEX_STATISTICSIndex statistical informationOne index
22SQL_DATATYPESInformation about user-defined typesOne user-defined type
23SQL_DATATYPE_DESCRIPTORSInformation about user-defined type configuration attributesOne attribute
24SQL_TABLE_RESOURCESInformation about resources used in a tableOne resource
25SQL_PLUGINSPlug-in informationOne plug-in
26SQL_PLUGIN_ROUTINESInformation about routines in a plug-inOne plug-in routine
27SQL_PLUGIN_ROUTINE_PARAMSInformation about parameters in a plug-in routineOne set of parameter information
28SQL_INDEX_TYPESInformation about index typesOne index type
29SQL_INDEX_RESOURCESInformation about resources used in an indexOne set of resource information
30SQL_INDEX_DATATYPEInformation about target items in an indexOne set of target item information (for one level)
31SQL_INDEX_FUNCTIONInformation about abstract data type functions used in an indexOne set of abstract data function information
32SQL_TYPE_RESOURCESInformation about resources used in a user-defined typeOne set of resource information
33SQL_INDEX_TYPE_FUNCTIONInformation about abstract data type functions used in an index that defines index typesOne index type (described by n rows)
34SQL_EXCEPTInformation about exclusion key values in an indexExclusion key groups in one index (described by n rows)
35SQL_FOREIGN_SERVERSDBMS information of the foreign server that is accessed by HiRDB using the HiRDB External Data Access facilityOne foreign server in one row
36SQL_USER_MAPPINGSMapping information used for accessing a foreign server using the HiRDB External Data Access facilityOne piece of mapping information in one row for one user on HiRDB
37SQL_IOS_GENERATIONSFor UNIX:
Generation information in the HiRDB file system areas when the inner replica facility is used
For Windows:
Used by the system (table is empty)
For UNIX:
One row per HiRDB file system area
For Windows:
None
38SQL_TRIGGERSInformation on the trigger that is inside the schemaOne trigger in one row
39SQL_TRIGGER_COLUMNSUPDATE trigger event column list informationOne piece of event column information in one row
40SQL_TRIGGER_DEF_SOURCETrigger definition source informationOne piece of trigger definition source information in n rows
41SQL_TRIGGER_USAGEResource information referenced inside a trigger action conditionOne resource name being referenced inside the trigger action condition in one row
42SQL_PARTKEYPartitioning key information of a matrix-partitioned tableOne piece of partitioning key information in one row
43SQL_PARTKEY_DIVISIONPartitioning condition value information of a matrix-partitioned tableOne piece of partitioning condition value information in one row
44SQL_AUDITSInformation on the monitoring targetOne object or information on one event for one user in one row
45SQL_REFERENTIAL_CONSTRAINTSReferential constraint conditionsInformation on one constraint in one row
46SQL_KEYCOLUMN_USAGEInformation on the columns that make up the external keysInformation on one column in one row
47SQL_TABLE_CONSTRAINTSInformation on the integrity constraints in a schemaInformation on one integrity constraint in one row
48SQL_CHECKSCheck constraint informationInformation on one check constraint in one row
49SQL_CHECK_COLUMNSInformation on columns used by a check constraintInformation on one column using one check constraint in one row
50SQL_DIV_TYPEPartitioning key information for matrix partitioning tables that combine key range partitioning and hash partitioningInformation on one partitioning key in one row
51SQL_SYSPARAMSRestriction information on the number of consecutive certification failures and the password character stringInformation on one setting item in one row, and restriction information on one number of consecutive certification failures or one password character string in n rows
Organization of this section
F.1 Examples of SQL statements for retrieval
F.2 Data dictionary table details