Data Dictionary Views
This chapter documents the predefined system views on the data dictionary tables.
SELECTaccess on these views, so that they may be examined by any user.
INFORMATION_SCHEMAviews are used to retrieve information about the objects in the data dictionary. See INFORMATION_SCHEMA.
INFO_SCHEMis an older version of this with shorter names, supported for backward compatibility. See INFO_SCHEM.
FIPS_DOCUMENTATIONviews contain information about SQL standards compliance features and Mimer SQL limits. See FIPS_DOCUMENTATION.
INFORMATION_SCHEMAview can be read with the statement (note the qualified form of
view-name):SELECT column-list FROM INFORMATION_SCHEMA.view-name WHERE condition
Many of the system views include only objects, privileges and so on relevant to the current ident (the description for each view indicates exactly what information is shown in the view).
Note: Some of the system views have columns designed to display information that is not currently supported by Mimer SQL (e.g. catalog names for database objects), in this situation the empty string ("") will be shown in these columns.
The tables in the data dictionary may be read directly only by the system administrator ident
SYSADMin the default installation. The base tables in the data dictionary are documented in the Mimer SQL System Management Handbook. The system administrator may, if desired, grant
SELECTaccess on the dictionary tables to other users.
No user may access the data dictionary views or tables directly for any purpose other than
SELECT. All data dictionary maintenance is performed by internal routines and is invisible to the user.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40