www.mimer.com/developer

Summary of Data Dictionary Tables

---

Table name	Description
API_FUNCTION	translation of id to function or module name. See API_FUNCTION.
AST_CODES	binary representation of the search condition of views in the database (for internal use). See AST_CODES.
AST_SOURCES	textual representation of view definitions and tables and domains with check constraints. See AST_SOURCES.
BACKUPS	databank backups recorded in the database. See BACKUPS.
CHAR_SETS	character sets in the database. See CHAR_SETS.
CHECK_CONSTRAINTS	check constraints defined for tables and domains. See CHECK_CONSTRAINTS.
COLLATIONS	character collations in the database. See COLLATIONS.
COLUMNS	columns in tables or views. See COLUMNS.
COLUMN_OBJECT_USE	columns that depend on other database objects. See COLUMN_OBJECT_USE.
COLUMN_PRIVILEGES	instances of privileges granted on a column. See COLUMN_PRIVILEGES.
DATABANKS	databanks in the database. See DATABANKS.
DOMAINS	domains in the database. See DOMAINS.
DOMAIN_CONSTRAINTS	constraints defined for domains. See DOMAIN_CONSTRAINTS
FIPS_FEATURES	details about all FIPS features. See FIPS_FEATURES.
FIPS_SIZING	details about FIPS limits. See FIPS_SIZING.
KEY_COLUMN_USAGE	columns in an index or in a primary, unique or foreign key. KEY_COLUMN_USAGE.
LEVEL2_RESTRICT	restrictions for domains legal for use by DB level 2. See LEVEL2_RESTRICT.
LEVEL2_VIEWCOL	columns of views acceptable by DB level 2. See LEVEL2_VIEWCOL.
LEVEL2_VIEWRES	restrictions for DB level 2. See LEVEL2_VIEWRES.
MANYROWS	dummy table with more than one row. See MANYROWS.
MESSAGE	translation of message code to message text. See MESSAGE.
MODULES	SQL-server modules in the database. See MODULES.
OBJECTS	objects in the database. See OBJECTS.
OBJECT_COLUMN_USE	columns referenced by other database objects. See OBJECT_COLUMN_USE.
OBJECT_OBJECT_USE	objects that have a dependency on another object. See OBJECT_OBJECT_USE.
ONEROW	dummy table containing one row. See ONEROW.
PARAMETERS	parameters of routines in the database. See PARAMETERS.
REFER_CONSTRAINTS	referential constraints in the database. See REFER_CONSTRAINTS.
ROUTINES	procedures and user-defined functions in the database. See ROUTINES.
SCHEMATA	schemas in the database. See SCHEMATA.
SEQUENCES	sequences in the database. See SEQUENCES.
SERVER_INFO	attributes of the current database system or server. See SERVER_INFO.
SEVERITY	severity levels and optional module for error codes. See SEVERITY.
SOURCE_DEFINITION	source definitions for defaults, check constraints, views, modules, procedures, functions and triggers. See SOURCE_DEFINITION.
SPECIFIC_NAMES	specific names of the routines in the database. See SPECIFIC_NAMES.
SQL_LANGUAGES	SQL standards and SQL dialects supported. See SQL_LANGUAGES.
SYNONYMS	synonyms and shadows in the database. See SYNONYMS.
TABLES	tables and views in the database. See TABLES.
TABLE_CONSTRAINTS	table constraints in the database. See TABLE_CONSTRAINTS.
TABLE_PRIVILEGES	instances of privileges granted on a table. See TABLE_PRIVILEGES.
TABLE_TYPES	the types of table supported. See TABLE_TYPES.
TRANSLATIONS	character translations in the database. See TRANSLATIONS.
TRIGGERED_COLUMNS	table columns explicitly specified in an UPDATE trigger event. See TRIGGERED_COLUMNS.
TRIGGERS	triggers in the database. See TRIGGERS.
TYPE_INFO	information about data types supported. See TYPE_INFO.
USAGE_PRIVILEGES	instances of privileges which grant the right to use a database object. See USAGE_PRIVILEGES.
USERS	idents (group, OS_USER, program or user) in the database. See USERS.
VIEWS	views in the database. See VIEWS.

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se