Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

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
Mimer SQL System Management Handbook TOC PREV NEXT INDEX