Nonstop Database, HiRDB Version 9 UAP Development Guide
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.
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 |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.