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