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.

Table B-1 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 8 UAP Development Guide.

Table B-1 Data dictionary tables

No.	Table name	Contents	Information coverage (per row)
1	SQL_PHYSICAL_FILES	HiRDB file information (correspondence between HiRDB file system name and RDAREA names)	1 HiRDB file
2	SQL_RDAREAS	Information such as RDAREA name, definition information, RDAREA type, number of tables stored, and number of indexes	1 RDAREA
3	SQL_TABLES	Owner and table names of tables in a database (including dictionary tables)	1 table
4	SQL_COLUMNS	Definition information related to a column, such as column name and data type	1 column
5	SQL_INDEXES	Owner and index names of indexes in a database (including dictionary tables)	1 index
6	SQL_USERS	Authorization identifier of the user who granted a user execution privilege and database access	1 user
7	SQL_RDAREA_PRIVILEGES	RDAREA usage privilege status	1 RDAREA of 1 authorization identifier
8	SQL_TABLE_PRIVILEGES	Table access privilege granting status	1 table of 1 authorization identifier
9	SQL_VIEW_TABLE_USAGE	Name of base table on which a view table is based	1 view table
10	SQL_VIEWS	View definition information	1 view table
11	SQL_DIV_TABLE	Table division information (division condition and name of RDAREA for storage, as specified in CREATE TABLE)	1 table per n rows
12	SQL_INDEX_COLINF	Name of column to which an index is assigned	1 index per n rows
13	SQL_DIV_INDEX	Index division information (name of RDAREA for storage)	1 index per n rows
14	SQL_DIV_COLUMN	BLOB type column division information (name of RDAREA for storage, as specified in CREATE TABLE)	1 column per n rows
15	SQL_ROUTINES	Routine definition information	1 routine per row
16	SQL_ROUTINE_RESOURCES	Information on resources used in a routine	1 routine per n rows
17	SQL_ROUTINE_PARAMS	Parameter definition information in a routine	1 routine per n rows
18	SQL_ALIASES	Information used by the system (empty)	None
19	SQL_TABLE_STATISTICS	Table statistical information	1 table
20	SQL_COLUMN_STATISTICS	Column statistical information	1 column
21	SQL_INDEX_STATISTICS	Index statistical information	1 index
22	SQL_DATATYPES	User-defined type information	1 user-defined type
23	SQL_DATATYPE_DESCRIPTORS	Information on an attribute that comprises a user-defined type	1 attribute
24	SQL_TABLE_RESOURCES	Resource information to be used in a table	1 resource
25	SQL_PLUGINS	Plug-in information	1 plug-in
26	SQL_PLUGIN_ROUTINES	Plug-in routine information	1 plug-in routine
27	SQL_PLUGIN_ROUTINE_PARAMS	Parameter information of a plug-in routine	1 parameter information item
28	SQL_INDEX_TYPES	Index type information	1 index type
29	SQL_INDEX_RESOURCES	Resource information to be used for an index	1 resource information item
30	SQL_INDEX_DATATYPE	Index item information	1 applicable information item (1 step)
31	SQL_INDEX_FUNCTION	Information on an abstract data type facility to be used for an index	Information on 1 abstract data type facility
32	SQL_TYPE_RESOURCES	Resource information to be used in a user-defined type	1 resource information item
33	SQL_INDEX_TYPE_FUNCTION	Information on an abstract data type facility that can be used by an index for which index type has been defined	1 index per n rows
34	SQL_EXCEPT	Information on index exception key values	Exception key group of 1 index per n rows
35	SQL_FOREIGN_SERVERS	DBMS information on foreign servers accessed by HiRDB when the HiRDB External Data Access facility is used	1 foreign server per row
36	SQL_USER_MAPPINGS	Mapping information on foreign servers accessed by HiRDB when the HiRDB External Data Access facility is used	1 mapping item for each user on HiRDB per row
37	SQL_IOS_GENERATIONS	Information used by the system (empty)	None
38	SQL_TRIGGERS	Trigger information in schemas	1 trigger per row
39	SQL_TRIGGER_COLUMNS	Event column list information on UPDATE triggers	1 event column data item per row
40	SQL_TRIGGER_DEF_SOURCE	Definition resource information on triggers	1 trigger definition source data item per n rows
41	SQL_TRIGGER_USAGE	Resource information referenced by trigger action conditions	1 resource name referenced by the trigger action conditions per row
42	SQL_PARTKEY	Information on partitioning keys of matrix-partitioned tables	1 partitioning key data item per row
43	SQL_PARTKEY_DIVISION	Information on partitioning condition values of matrix-partitioned tables	1 partitioning condition value data item per row
44	SQL_AUDITS	Information on audits	1 event data item for an object or user per row
45	SQL_REFERENTIAL_CONSTRAINTS	Match state of referential constraints	1 constraint per row
46	SQL_KEYCOLUMN_USAGE	Information on columns comprising foreign keys	1 column per row
47	SQL_TABLE_CONSTRAINTS	Information on integrity constraints in schemas	1 integrity constraint per row
48	SQL_CHECKS	Information on check constraints	1 check constraint per row
49	SQL_CHECK_COLUMNS	Information on columns used by check constraints	1 column used by a check constraint per row
50	SQL_DIV_TYPE	Information on partitioning keys in matrix partitioning tables that combine key range partitioning and hash partitioning	1 partitioning key per row
51	SQL_SYSPARAMS	Information on restrictions on number of consecutive certification failures and on password character string restrictions	1 setting item per row, or one permitted number of consecutive certification failures specifications or one password character string restriction specification per n rows