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

Number	Table name	Description	Row contents
1	SQL_PHYSICAL_FILES	HiRDB file information (correspondences between HiRDB file system names and RDAREA names)	One HiRDB file
2	SQL_RDAREAS	Information such as the RDAREA names, their definition information, the RDAREA types, the number of stored tables, and number of indexes	One RDAREA
3	SQL_TABLES	Owner name and table name of each table (including dictionary tables) in the database	One table
4	SQL_COLUMNS	Column definition information, such as the column names and their data types	One column
5	SQL_INDEXES	Owner name and index name of each index (including dictionary tables) in the database	One index
6	SQL_USERS	Execution privileges and authorization identifiers of users authorized to access the database	One user
7	SQL_RDAREA_PRIVILEGES	Grants of RDAREA usage privileges	Use of one RDAREA for one authorization identifier
8	SQL_TABLE_PRIVILEGES	Grants of table access privileges	Access to one table for one authorization identifier
9	SQL_VIEW_TABLE_USAGE	Names of base tables used for view tables	One view table
10	SQL_VIEWS	View definition information	One view table
11	SQL_DIV_TABLE	Table partitioning information (partitioning conditions specified in CREATE TABLE and names of RDAREAs that store partitioned tables)	One table (described by n rows)
12	SQL_INDEX_COLINF	Names of columns to which indexes are assigned	One index (described by n rows)
13	SQL_DIV_INDEX	Index partitioning information (storage RDAREA names)	One index (described by n rows)
14	SQL_DIV_COLUMN	BLOB-type column partitioning information (storage RDAREA names specified when CREATE TABLE was executed)	One column (described by n rows)
15	SQL_ROUTINES	Routine definition information	One routine (described by one row)
16	SQL_ROUTINE_RESOURCES	Information about resources used in a routine	One routine (described by n rows)
17	SQL_ROUTINE_PARAMS	Information about parameter definitions in a routine	One routine (described by n rows)
18	SQL_ALIASES	For 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
19	SQL_TABLE_STATISTICS	Table statistical information	One table
20	SQL_COLUMN_STATISTICS	Column statistical information	One column
21	SQL_INDEX_STATISTICS	Index statistical information	One index
22	SQL_DATATYPES	Information about user-defined types	One user-defined type
23	SQL_DATATYPE_DESCRIPTORS	Information about user-defined type configuration attributes	One attribute
24	SQL_TABLE_RESOURCES	Information about resources used in a table	One resource
25	SQL_PLUGINS	Plug-in information	One plug-in
26	SQL_PLUGIN_ROUTINES	Information about routines in a plug-in	One plug-in routine
27	SQL_PLUGIN_ROUTINE_PARAMS	Information about parameters in a plug-in routine	One set of parameter information
28	SQL_INDEX_TYPES	Information about index types	One index type
29	SQL_INDEX_RESOURCES	Information about resources used in an index	One set of resource information
30	SQL_INDEX_DATATYPE	Information about target items in an index	One set of target item information (for one level)
31	SQL_INDEX_FUNCTION	Information about abstract data type functions used in an index	One set of abstract data function information
32	SQL_TYPE_RESOURCES	Information about resources used in a user-defined type	One set of resource information
33	SQL_INDEX_TYPE_FUNCTION	Information about abstract data type functions used in an index that defines index types	One index type (described by n rows)
34	SQL_EXCEPT	Information about exclusion key values in an index	Exclusion key groups in one index (described by n rows)
35	SQL_FOREIGN_SERVERS	DBMS information of the foreign server that is accessed by HiRDB using the HiRDB External Data Access facility	One foreign server in one row
36	SQL_USER_MAPPINGS	Mapping information used for accessing a foreign server using the HiRDB External Data Access facility	One piece of mapping information in one row for one user on HiRDB
37	SQL_IOS_GENERATIONS	For 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
38	SQL_TRIGGERS	Information on the trigger that is inside the schema	One trigger in one row
39	SQL_TRIGGER_COLUMNS	UPDATE trigger event column list information	One piece of event column information in one row
40	SQL_TRIGGER_DEF_SOURCE	Trigger definition source information	One piece of trigger definition source information in n rows
41	SQL_TRIGGER_USAGE	Resource information referenced inside a trigger action condition	One resource name being referenced inside the trigger action condition in one row
42	SQL_PARTKEY	Partitioning key information of a matrix-partitioned table	One piece of partitioning key information in one row
43	SQL_PARTKEY_DIVISION	Partitioning condition value information of a matrix-partitioned table	One piece of partitioning condition value information in one row
44	SQL_AUDITS	Information on the monitoring target	One object or information on one event for one user in one row
45	SQL_REFERENTIAL_CONSTRAINTS	Referential constraint conditions	Information on one constraint in one row
46	SQL_KEYCOLUMN_USAGE	Information on the columns that make up the external keys	Information on one column in one row
47	SQL_TABLE_CONSTRAINTS	Information on the integrity constraints in a schema	Information on one integrity constraint in one row
48	SQL_CHECKS	Check constraint information	Information on one check constraint in one row
49	SQL_CHECK_COLUMNS	Information on columns used by a check constraint	Information on one column using one check constraint in one row
50	SQL_DIV_TYPE	Partitioning key information for matrix partitioning tables that combine key range partitioning and hash partitioning	Information on one partitioning key in one row
51	SQL_SYSPARAMS	Restriction information on the number of consecutive certification failures and the password character string	Information 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