This section discusses the retrieval and referencing of data dictionary tables.

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.

The following table lists the data dictionary tables that can be referenced.

Table G-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_TABLE_STATISTICS	Table statistical information	One table
19	SQL_COLUMN_STATISTICS	Column statistical information	One column
20	SQL_INDEX_STATISTICS	Index statistical information	One index
21	SQL_DATATYPES	Information about user-defined types	One user-defined type
22	SQL_DATATYPE_DESCRIPTORS	Information about user-defined type configuration attributes	One attribute
23	SQL_TABLE_RESOURCES	Information about resources used in a table	One resource
24	SQL_PLUGINS	Plug-in information	One plug-in
25	SQL_PLUGIN_ROUTINES	Information about routines in a plug-in	One plug-in routine
26	SQL_PLUGIN_ROUTINE_PARAMS	Information about parameters in a plug-in routine	One set of parameter information
27	SQL_INDEX_TYPES	Information about index types	One index type
28	SQL_INDEX_RESOURCES	Information about resources used in an index	One set of resource information
29	SQL_INDEX_DATATYPE	Information about target items in an index	One set of target item information (for one level)
30	SQL_INDEX_FUNCTION	Information about abstract data type functions used in an index	One set of abstract data function information
31	SQL_TYPE_RESOURCES	Information about resources used in a user-defined type	One set of resource information
32	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)
33	SQL_EXCEPT	Information about exclusion key values in an index	Exclusion key groups in one index (described by n rows)
34	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
35	SQL_TRIGGERS	Information on the trigger that is inside the schema	One trigger in one row
36	SQL_TRIGGER_COLUMNS	UPDATE trigger event column list information	One piece of event column information in one row
37	SQL_TRIGGER_DEF_SOURCE	Trigger definition source information	One piece of trigger definition source information in n rows
38	SQL_TRIGGER_USAGE	Resource information referenced inside a trigger action condition	One resource name being referenced inside the trigger action condition in one row
39	SQL_PARTKEY	Partitioning key information of a matrix-partitioned table	One piece of partitioning key information in one row
40	SQL_PARTKEY_DIVISION	Partitioning condition value information of a matrix-partitioned table	One piece of partitioning condition value information in one row
41	SQL_AUDITS	Information on the monitoring target	One object or information on one event for one user in one row
42	SQL_REFERENTIAL_CONSTRAINTS	Referential constraint conditions	Information on one constraint in one row
43	SQL_KEYCOLUMN_USAGE	Information on the columns that make up the external keys	Information on one column in one row
44	SQL_TABLE_CONSTRAINTS	Information on the integrity constraints in a schema	Information on one integrity constraint in one row
45	SQL_CHECKS	Check constraint information	Information on one check constraint in one row
46	SQL_CHECK_COLUMNS	Information on columns used by a check constraint	Information on one column using one check constraint in one row
47	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
48	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
49	SQL_INDEX_XMLINF	Information on the component substructure paths of a substructure index	Information on one index in one row
50	SQL_SEQUENCES	Information on the sequence generator	Information on one sequence generator in one row

Organization of this section

G.1 Examples of SQL statements for retrieval

G.2 Data dictionary table details