Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


INFORMATION_SCHEMA


The table below summarizes the system views that are part of the schema INFORMATION_SCHEMA (view names appear in their unqualified form):

View name
Description
ASSERTIONS
Owned assertions. See ASSERTIONS
CHARACTER_SETS
Accessible character sets. See CHARACTER_SETS
CHECK_CONSTRAINTS
Owned check constraints. See CHECK_CONSTRAINTS.
COLLATIONS
Accessible collations. See COLLATIONS.
COLUMN_DOMAIN_USAGE
Columns defined using to owned domains. See COLUMN_DOMAIN_USAGE.
COLUMN_PRIVILEGES
Privileges granted on accessible table columns. See COLUMN_PRIVILEGES.
COLUMNS
Accessible table columns. See COLUMNS.
CONSTRAINT_COLUMN_USAGE
Columns referenced by owned referential, unique, check or assertion constraints. CONSTRAINT_COLUMN_USAGE.
CONSTRAINT_TABLE_USAGE
Tables on which owned referential, unique, check or assertion constraints are defined. See CONSTRAINT_TABLE_USAGE.
DOMAIN_CONSTRAINTS
Constraints of accessible domains. See DOMAIN_CONSTRAINTS
DOMAINS
Accessible domains. See DOMAINS.
EXT_COLUMN_REMARKS
Comments for accessible table columns. See EXT_COLUMN_REMARKS
EXT_DATABANKS
Accessible databanks. See EXT_DATABANKS.
EXT_IDENTS
Accessible authorization idents. See EXT_IDENTS.
EXT_INDEX_COLUMN_USAGE
Accessible table columns on which indexes depend. EXT_INDEX_COLUMN_USAGE.
EXT_INDEXES
Accessible indexes. See EXT_INDEXES.
EXT_OBJECT_IDENT_USAGE
Accessible objects created by authorization ident. See EXT_OBJECT_IDENT_USAGE.
EXT_OBJECT_OBJECT_USED
Accessible objects used by other objects. See EXT_OBJECT_OBJECT_USED.
EXT_OBJECT_OBJECT_USING
Accessible objects using other objects. See EXT_OBJECT_OBJECT_USING.
EXT_OBJECT_PRIVILEGES
Object privileges granted to an authorization ident. EXT_OBJECT_PRIVILEGES.
EXT_ROUTINE_MODULE_DEFINITION
Source definition for routines defined in modules. See EXT_ROUTINE_MODULE_DEFINITION.
EXT_ROUTINE_MODULE_USAGE
Accessible routines in a module. See EXT_ROUTINE_MODULE_USAGE.
EXT_SEQUENCES
Accessible sequences. See EXT_SEQUENCES.
EXT_SHADOWS
Accessible shadows. See EXT_SHADOWS.
EXT_SOURCE_DEFINITION
Text definition for owned objects. See EXT_SOURCE_DEFINITION.
EXT_STATISTICS
Statistics for table. See EXT_STATISTICS.
EXT_SYNONYMS
Accessible synonyms. See EXT_SYNONYMS.
EXT_SYSTEM_PRIVILEGES
System privileges granted to an authorization ident. See EXT_SYSTEM_PRIVILEGES.
EXT_TABLE_DATABANK_USAGE
Owned databanks on which tables depend. See EXT_TABLE_DATABANK_USAGE.
KEY_COLUMN_USAGE
Table columns constrained as keys by owned constraints. See KEY_COLUMN_USAGE.
MODULES
Owned modules. See MODULES.
PARAMETERS
Parameters of accessible routines. See MODULES.
REFERENTIAL_CONSTRAINTS
Owned referential constraints. See REFERENTIAL_CONSTRAINTS.
ROUTINE_COLUMN_USAGE
Owned table columns on which routines depend. See ROUTINE_COLUMN_USAGE.
ROUTINE_PRIVILEGES
Privileges held on accessible routines. See ROUTINE_PRIVILEGES.
ROUTINE_TABLE_USAGE
Owned tables on which routines depend. See ROUTINE_TABLE_USAGE.
ROUTINES
Accessible routines. ROUTINES.
SCHEMATA
Owned schemas. See SCHEMATA.
SQL_LANGUAGES
Conformance levels for supported SQL language options and dialects. See SQL_LANGUAGES.
TABLE_CONSTRAINTS
Owned table constraints. See TABLE_CONSTRAINTS.
TABLE_PRIVILEGES
Privileges held on accessible tables. See TABLE_PRIVILEGES.
TABLES
Accessible tables. See TABLES.
TRANSLATIONS
Accessible character set translations. See TRANSLATIONS.
TRIGGERED_UPDATE_COLUMNS
Owned columns referenced from UPDATE trigger column lists. See TRIGGERED_UPDATE_COLUMNS.
TRIGGER_COLUMN_USAGE
Owned columns referenced from a trigger action. See TRIGGER_COLUMN_USAGE.
TRIGGER_TABLE_USAGE
Tables on which owned triggers depend. See TRIGGER_TABLE_USAGE.
TRIGGERS
Owned triggers. See TRIGGERS.
USAGE_PRIVILEGES
USAGE privilege held on accessible objects. See USAGE_PRIVILEGES.
VIEW_COLUMN_USAGE
Columns on which owned views depend. See VIEW_COLUMN_USAGE.
VIEW_TABLE_USAGE
Tables on which owned views depend. VIEW_TABLE_USAGE.
VIEWS
Accessible views. SeeVIEWS.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX