The table below summarizes the system views that are part of the schema INFO_SCHEM (view names appear in their unqualified form):
CHARACTER_SETS Accessible character sets and their default collations. COLLATIONS Accessible collations. COLUMN_PRIVILEGES Privileges on table columns. COLUMNS Accessible table columns. INDEXES Accessible indexes. SCHEMATA All schemas in the database. SERVER_INFO Attributes of the current database server. SQL_LANGUAGES All supported SQL standards and dialects. TABLE_PRIVILEGES Privileges on tables. TABLES Accessible tables. TRANSLATIONS Accessible character set translations. USAGE_PRIVILEGES Privileges on character sets and collations. VIEWS Accessible views.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40