Views of the INFORMATION_SCHEMA

In the INFORMATION_SCHEMA, you will find information on database objects. Each authorization identifier only has access to the objects for which it is authorized. The views of the INFORMATION_SCHEMA conform to the SQL standard with regard to objects defined in SESAM/SQL and in the SQL standard. The INFORMATION_SCHEMA includes additional views for SESAM/SQL extensions.

The table below indicates which view of the INFORMATION_SCHEMA contains information on which database object.

The views of the INFORMATION_SCHEMA are described in alphabetical order in the subsequent sections.

Object	View name	Information on
Schema	SCHEMATA	Schemas in the database
Table	TABLES	Tables in the database
	BASE_TABLES	Base tables in the database
	PARTITIONS	Partitions of the base tables
	VIEW_TABLE_USAGE	Tables on which the views are based
	CONSTRAINT_TABLE_USAGE	Tables on which integrity constraints are based
View	VIEWS	Views of the database
Column	COLUMNS	Columns in the database
	BASE_TABLE_COLUMNS	Columns in the base tables
	VIEW_COLUMN_USAGE	Columns on which views are based
	CONSTRAINT_COLUMN_USAGE	Columns on which integrity constraints are based
	INDEX_COLUMN_USAGE	Columns on which indexes are based
	KEY_COLUMN_USAGE	Columns for which a primary key or UNIQUE constraint is defined
Privilege	TABLE_PRIVILEGES	Table privileges
	COLUMN_PRIVILEGES	Column privileges
	CATALOG_PRIVILEGES	Special privileges
	USAGE_PRIVILEGES	USAGE privileges
	ROUTINE_PRIVILEGES	Privileges for routines
Index	INDEXES	Indexes in the database
Integrity constraint	TABLE_CONSTRAINTS	Integrity constraints
	REFERENTIAL_CONSTRAINTS	Referential constraints
	CHECK_CONSTRAINTS	Check constraints
Storage group	STOGROUPS	Storage groups in the database
Volume	STOGROUP_VOLUME_USAGE	Volumes used for storage groups
Space	SPACES	Spaces
Routines	PARAMETERS	Parameters of routines
	ROUTINES	Routines
	ROUTINE_ROUTINE_USAGE	Routines in other routines
	ROUTINE_TABLE_USAGE	Tables in routines
	ROUTINE_COLUMN_USAGE	Columns in routines
	VIEW_ROUTINE_USAGE	Routines in views
User	USERS	Authorization identifier
	SYSTEM_ENTRIES	System entries
DA-LOG-file	DA_LOGS	DA-LOG files
Media table	MEDIA_DESCRIPTIONS MEDIA_RECORDS	Media records of the database specific files
Recovery unit	RECOVERY_UNITS	Recovery units for spaces
Character set	CHARACTER_SETS	Character set
Sort sequence	COLLATIONS	Sort sequence
Transliteration	TRANSLATIONS	Transliterations
Features and Conformance	SQL_FEATURES SQL_IMPL_INFO SQL_LANGUAGES_S SQL_SIZING	Features, subfeatures, implementations, implemented host languages, embedments and implementation-specific maximum values

Table 62: Views of the INFORMATION_SCHEMA (section 2 of 2)