INFORMATION

http://developer.mimer.com

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_STATEMENTS

Shows all precompiled statements available to the current IDENT. See EXT_STATEMENTS.

EXT_STATEMENT_DEFINITION

Shows a textual definition of the precompiled statements available to the current IDENT. See EXT_STATEMENT_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.

ASSERTIONS

The ASSERTIONS system view shows all assertions owned by the current ident.

Column name

Data type

Description

CONSTRAINT_CATALOG

VARCHAR(128)

The name of the catalog containing the assertion.

CONSTRAINT_SCHEMA

VARCHAR(128)

The name of the schema containing the assertion.

CONSTRAINT_NAME

VARCHAR(128)

The name of the assertion.

IS_DEFERRABLE

VARCHAR(3)

One of:
YES = the assertion is deferrable
NO = the assertion is not deferrable

INITIALLY_DEFERRED

VARCHAR(3)

One of:
YES = the assertion is immediate
NO = the assertion is deferred.

CHARACTER_SETS

The CHARACTER_SETS system view describes each character set to which the current ident has USAGE privilege.

Column name

Data type

Description

CHARACTER_SET_CATALOG

VARCHAR(128)

The name of the catalog containing the character set.

CHARACTER_SET_SCHEMA

VARCHAR(128)

The name of the schema containing the character set.

CHARACTER_SET_NAME

VARCHAR(128)

The name of the character set.

FORM_OF_USE

VARCHAR(128)

A user-defined name that indicates the form-of-use of the character set.

NUMBER_OF_CHARACTERS

INTEGER

The number of characters in the character set.

DEFAULT_COLLATE_CATALOG

VARCHAR(128)

The name of the catalog containing the default collation for the character set.

DEFAULT_COLLATE_SCHEMA

VARCHAR(128)

The name of the schema containing the default collation for the character set.

DEFAULT_COLLATE_NAME

VARCHAR(128)

The name of the default collation for the character set.

CHECK_CONSTRAINTS

The CHECK_CONSTRAINTS system view lists the check constraints that are owned by the current ident.

Column name

Data type

Description

CONSTRAINT_CATALOG

VARCHAR(128)

The name of the catalog containing the check constraint.

CONSTRAINT_SCHEMA

VARCHAR(128)

The name of the schema containing the check constraint.

CONSTRAINT_NAME

VARCHAR(128)

The name of the check constraint.

CHECK_CLAUSE

NCHAR VARYING(400)

The character representation of the search condition used in the check clause. If the character representation does not fit, the value is NULL.

COLLATIONS

The COLLATIONS system view describes each collation to which the current ident has access.

Column name

Data type

Description

COLLATION_CATALOG

VARCHAR(128)

The name of the catalog containing the collation.

COLLATION_SCHEMA

VARCHAR(128)

The name of the schema containing the collation.

COLLATION_NAME

VARCHAR(128)

Name of the collation.

CHARACTER_SET_CATALOG

VARCHAR(128)

The name of the catalog containing the character set on which the collation is defined.

CHARACTER_SET_SCHEMA

VARCHAR(128)

The name of the schema containing the character set on which the collation is defined.

CHARACTER_SET_NAME

VARCHAR(128)

The name of the character set on which the collation is defined.

PAD_ATTRIBUTE

VARCHAR(20)

One of the following values:
NO PAD = the collation has the no pad attribute
PAD SPACE = the collation has the pad space attribute.

COLUMN_DOMAIN_USAGE

The COLUMN_DOMAIN_USAGE system view lists the table columns which depend on domains owned by the current ident.

Column name

Data type

Description

DOMAIN_CATALOG

VARCHAR(128)

The name of the catalog containing the domain.

DOMAIN_SCHEMA

VARCHAR(128)

The name of the schema containing the domain.

DOMAIN_NAME

VARCHAR(128)

The name of the domain.

TABLE_CATALOG

VARCHAR(128)

The name of the catalog containing the table.

TABLE_SCHEMA

VARCHAR(128)

The name of the schema containing the table.

TABLE_NAME

VARCHAR(128)

The name of the table.

COLUMN_NAME

VARCHAR(128)

The name of the column.

COLUMN_PRIVILEGES

The COLUMN_PRIVILEGES system view lists privileges on table columns that were granted by the current ident and privileges on table columns that were granted to the current ident or to PUBLIC.

Column name

Data type

Description

GRANTOR

VARCHAR(128)

The name of the ident who granted the privilege.

GRANTEE

VARCHAR(128)

The name of the ident to whom the privilege was granted. Granting a privilege to PUBLIC will result in only one row (per privilege granted) in this view and the name PUBLIC will be shown.

TABLE_CATALOG

VARCHAR(128)

The name of the catalog containing the table.

TABLE_SCHEMA

VARCHAR(128)

The name of the schema containing the table.

TABLE_NAME

VARCHAR(128)

The name of the table containing the column on which the column privilege has been granted.

COLUMN_NAME

VARCHAR(128)

The name of the column on which the privilege has been granted.

PRIVILEGE_TYPE

VARCHAR(20)

A value describing the type of the column privilege that was granted. One of:

INSERT
REFERENCES
SELECT
UPDATE.
Note that when multiple table column privileges are granted to the same user at the same time (e.g. when the keyword ALL is used), multiple rows appear in this view (one for each privilege granted).

IS_GRANTABLE

VARCHAR(3)

One of:
YES = the privilege is held WITH GRANT OPTION
NO = the privilege is not held WITH GRANT OPTION.

COLUMNS

The COLUMNS system view lists the table columns to which the current ident has access.

Column name

Data type

Description

TABLE_CATALOG

VARCHAR(128)

The name of the catalog containing the table or view.

TABLE_SCHEMA

VARCHAR(128)

The name of the schema containing the table or view.

TABLE_NAME

VARCHAR(128)

The name of the table or view.

COLUMN_NAME

VARCHAR(128)

The name of the column of the table or view.

ORDINAL_POSITION

INTEGER

The ordinal position of the column in the table. The first column in the table is number 1.

COLUMN_DEFAULT

NCHAR VARYING(400)

This shows the default value for the column.
If the default value is a character string, the value shown is the string enclosed in single quotes.
If the default value is a numeric literal, the value is shown in its original character representation without enclosing quotes.
If the default value is a DATE, TIME or TIMESTAMP, the value shown is the appropriate keyword (e.g. DATE) followed by the literal representation of the value enclosed in single quotes (see DATE, TIME and TIMESTAMP Literals for a description of DATE, TIME and TIMESTAMP literals).
If the default value is a pseudo-literal, the value shown is the appropriate keyword (e.g. CURRENT_DATE) without enclosing quotes.
If the default value is the NULL value, the value shown is the keyword NULL without enclosing quotes.
If the default value cannot be represented without truncation, then TRUNCATED is shown without enclosing quotes.
If no default value was specified then its value is the NULL value.
The value of COLUMN_DEFAULT is syntactically suitable for use in specifying default-value in a CREATE TABLE or ALTER TABLE statement (except when TRUNCATED is shown).

IS_NULLABLE

VARCHAR(3)

One of:
NO = the column is not nullable, according to the rules in the international standard
YES = the NULL value is allowed in the column.

DATA_TYPE

VARCHAR(30)

Identifies the data type of the column.
Can be one of the following:
BIGINT
BINARY
BINARY VARYING
BINARY LARGE OBJECT
CHARACTER
CHARACTER LARGE OBJECT
NATIONAL CHARACTER
NATIONAL CHARACTER VARYING
CHARACTER VARYING
DATE
DECIMAL
DOUBLE PRECISION
FLOAT
Float(p)
INTEGER
Integer(p)
INTERVAL
NUMERIC
REAL
SMALLINT
TIME
TIMESTAMP.

LOB_MAXIMUM_LENGTH

BIGINT

For the LOB data type, this shows the maximum length in bytes. For all other data types it is the NULL value.

CHARACTER_MAXIMUM
_LENGTH

INTEGER

For CHARACTER, LOB and BINARY data types, this shows the maximum length in characters or bytes. For all other data types it is the NULL value.

CHARACTER_OCTET
_LENGTH

INTEGER

For CHARACTER, LOB and BINARY data types, this shows the maximum length in octets. For all other data types it is the NULL value.

For single octet character sets, this is the same as CHARACTER_MAX_LENGTH.

NUMERIC_PRECISION

INTEGER

For NUMERIC data types, this shows the total number of significant digits allowed in the column. For all other data types it is the NULL value.

NUMERIC_PRECISION
_RADIX

INTEGER

This shows whether the NUMERIC_PRECISION is given in a binary or decimal radix. The numeric radix is always decimal in Mimer SQL, therefore the value 10 is always shown for numeric data types. For all other data types it is the NULL value.

NUMERIC_SCALE

INTEGER

For NUMERIC and DECIMAL, this defines the total number of significant digits to the right of the decimal point.

For BIGINT, INTEGER and SMALLINT, this is 0.

For all other data types, it is the NULL value.

DATETIME_PRECISION

INTEGER

For DATE, TIME, TIMESTAMP and INTERVAL data types, this column contains the number of digits of precision for the fractional seconds component.

For other data types it is the NULL value.

INTERVAL_TYPE

VARCHAR(30)

For INTERVAL data types, this is a character string specifying the interval qualifier. Can be one of:
YEAR
YEAR TO MONTH
DAY
HOUR
MINUTE
SECOND
DAY TO HOUR
DAY TO MINUTE
DAY TO SECOND
HOUR TO MINUTE
HOUR TO SECOND
MINUTE TO SECOND.

For other data types it is the NULL value.

INTERVAL_PRECISION

INTEGER

For INTERVAL data types, this is the number of significant digits for the interval leading precision (see Interval Qualifiers).

For other data types it is the NULL value.

CHARACTER_SET
_CATALOG

VARCHAR(128)

The name of the catalog containing the character set used by the column.

CHARACTER_SET
_SCHEMA

VARCHAR(128)

The name of the schema containing the character set used by the column.

CHARACTER_SET_NAME

VARCHAR(128)

The name of the character set used by the column.

COLLATION_CATALOG

VARCHAR(128)

The name of the catalog containing the collation used by the column.

COLLATION_SCHEMA

VARCHAR(128)

The name of the schema containing the collation used by the column.

COLLATION_NAME

VARCHAR(128)

The name of the collation used by the column.

DOMAIN_CATALOG

VARCHAR(128)

The name of the catalog containing the domain used by the column.

DOMAIN_SCHEMA

VARCHAR(128)

The name of the schema containing the domain used by the column.

DOMAIN_NAME

VARCHAR(128)

The name of the domain used by the column.

USER_DEFINED_TYPE
_CATALOG

VARCHAR(128)

The name of the user-defined type catalog.

USER_DEFINED_TYPE
_SCHEMA

VARCHAR(128)

The name of the user-defined type schema.

USER_DEFINED_TYPE
_NAME

VARCHAR(128)

The name of the user-defined type name.

CONSTRAINT_COLUMN_USAGE

The CONSTRAINT_COLUMN_USAGE system view lists the table columns on which constraints (referential constraints, unique constraints, check constraints and assertions) that are owned by the current ident are defined.

Column name

Data type

Description

TABLE_CATALOG

VARCHAR(128)

The name of the catalog containing the table.

TABLE_SCHEMA

VARCHAR(128)

The name of the schema containing the table.

TABLE_NAME

VARCHAR(128)

The name of the table.

COLUMN_NAME

VARCHAR(128)

The name of the table column.

CONSTRAINT_CATALOG

VARCHAR(128)

The name of the catalog containing the constraint.

CONSTRAINT_NAME

VARCHAR(128)

The name of the constraint.

CONSTRAINT_TABLE_USAGE

The CONSTRAINT_TABLE_USAGE system view lists the tables on which constraints (referential constraints, unique constraints, check constraints and assertions) that are owned by the current ident are defined.

Column name

Data type

Description

TABLE_CATALOG

VARCHAR(128)

The name of the catalog containing the table.

TABLE_SCHEMA

VARCHAR(128)

The name of the schema containing the table.

TABLE_NAME

VARCHAR(128)

The name of the table.

CONSTRAINT_CATALOG

VARCHAR(128)

The name of the catalog containing the constraint.

CONSTRAINT_SCHEMA

VARCHAR(128)

The name of the schema containing the constraint.

CONSTRAINT_NAME

VARCHAR(128)

The name of the constraint.

DOMAIN_CONSTRAINTS

The DOMAIN_CONSTRAINTS system view lists the domain constraints of domains to which the current ident has access.

Column name

Data type

Description

CONSTRAINT_CATALOG

VARCHAR(128)

The name of the catalog containing the constraint.

CONSTRAINT_SCHEMA

VARCHAR(128)

The name of the schema containing the constraint.

CONSTRAINT_NAME

VARCHAR(128)

Name of the constraint.

DOMAIN_CATALOG

VARCHAR(128)

The name of the catalog containing the domain on which the constraint is defined.

DOMAIN_SCHEMA

VARCHAR(128)

The name of the schema containing the domain on which the constraint is defined.

DOMAIN_NAME

VARCHAR(128)

The name of the domain on which the constraint is defined.

IS_DEFERRABLE

VARCHAR(3)

One of:
YES = the constraint is deferrable
NO = the constraint is not deferrable.

INITIALLY_DEFERRED

VARCHAR(3)

One of:
YES = the constraint is immediate
NO = the constraint is deferred.

DOMAINS

The DOMAINS system view describes each domain to which the current ident has USAGE privilege.

.

Column name

Data type

Description

DOMAIN_CATALOG

VARCHAR(128)

The name of the catalog containing the domain.

DOMAIN_SCHEMA

VARCHAR(128)

The name of the schema containing the domain.

DOMAIN_NAME

VARCHAR(128)

Name of the domain.

DATA_TYPE

VARCHAR(30)

Identifies the data type of the domain.
Can be one of the following:
BIGINT
BINARY
BINARY VARYING
BINARY LARGE OBJECT
CHARACTER
CHARACTER LARGE OBJECT
NATIONAL CHARACTER
NATIONAL CHARACTER VARYING
CHARACTER VARYING
DATE
DECIMAL
DOUBLE PRECISION
FLOAT
Float(p)
INTEGER
Integer(p)
INTERVAL
NUMERIC
REAL
SMALLINT
TIME
TIMESTAMP.

LOB_MAXIMUM_LENGTH

BIGINT

For the LOB data type, this shows the maximum length in bytes. For all other data types it is the NULL value.

CHARACTER_MAXIMUM
_LENGTH

INTEGER

For CHARACTER, LOB and BINARY data types, this shows the maximum length in characters or bytes. For all other data types it is the NULL value.

CHARACTER_OCTET_LENGTH

INTEGER

For CHARACTER, LOB and BINARY data types, this shows the maximum length in octets. For all other data types it is the NULL value.
For single octet character sets, this is the same as CHARACTER_MAX_LENGTH.

CHARACTER_SET_CATALOG

VARCHAR(128)

The name of the catalog containing the character set used by the domain. NULL if not CHARACTER data type.

CHARACTER_SET_SCHEMA

VARCHAR(128)

The name of the schema containing the character set used by the domain. NULL if not CHARACTER data type.

CHARACTER_SET_NAME

VARCHAR(128)

The name of the character set used by the domain. NULL if not CHARACTER data type.

COLLATION_CATALOG

VARCHAR(128)

The name of the catalog containing the default collation for the character set. NULL if not CHARACTER data type.

COLLATION_SCHEMA

VARCHAR(128)

The name of the schema containing the default collation for the character set. NULL if not CHARACTER data type.

COLLATION_NAME

VARCHAR(128)

The name of the default collation for the character set. NULL if not CHARACTER data type.

NUMERIC_PRECISION

INTEGER

For NUMERIC data types, this shows the total number of significant digits allowed in the column. For all other data types it is the NULL value.

NUMERIC_PRECISION
_RADIX

INTEGER

This shows whether the NUMERIC_PRECISION is given in a binary or decimal radix. The numeric radix is always decimal in Mimer SQL, therefore the value 10 is always shown for numeric data types. For all other data types it is the NULL value.

NUMERIC_SCALE

INTEGER

For NUMERIC and DECIMAL, this defines the total number of significant digits to the right of the decimal point. For BIGINT, INTEGER and SMALLINT, this is 0. For all other data types, it is the NULL value.

DATETIME_PRECISION

INTEGER

For DATE, TIME, TIMESTAMP and INTERVAL data types, this column contains the number of digits of precision for the fractional seconds component. For other data types it is the NULL value.

INTERVAL_TYPE

VARCHAR(30)

For INTERVAL data types, this is a character string specifying the interval qualifier for the named interval data type (see Interval Qualifiers). For other data types it is the NULL value.

INTERVAL_PRECISION

INTEGER

For INTERVAL data types, this is the number of significant digits for the interval leading precision (see Interval Qualifiers). For other data types it is the NULL value.

DOMAIN_DEFAULT

NCHAR VARYING(400)

This shows the default value for the domain.
If the default value is a character string, the value shown is the string enclosed in single quotes.
If the default value is a numeric literal, the value is shown in its original character representation without enclosing quotes.
If the default value is a DATE, TIME or TIMESTAMP, the value shown is the appropriate keyword (e.g. DATE) followed by the literal representation of the value enclosed in single quotes (see DATE, TIME and TIMESTAMP Literals for a description of DATE, TIME and TIMESTAMP literals).
If the default value is a pseudo-literal, the value shown is the appropriate keyword (e.g. CURRENT_DATE) without enclosing quotes.
If the default value is the NULL value, the value shown is the keyword NULL without enclosing quotes.
If the default value cannot be represented without truncation, then TRUNCATED is shown without enclosing quotes.
If no default value was specified then its value is the NULL value.
The value of DOMAIN_DEFAULT is syntactically suitable for use in specifying default-value in a CREATE TABLE or ALTER TABLE statement (except when TRUNCATED is shown).

EXT_COLUMN_REMARKS

The EXT_COLUMN_REMARKS system view shows remarks for columns that are accessible by the current ident.

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_STATEMENTS	Shows all precompiled statements available to the current IDENT. See EXT_STATEMENTS.
EXT_STATEMENT_DEFINITION	Shows a textual definition of the precompiled statements available to the current IDENT. See EXT_STATEMENT_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.

Column name	Data type	Description
CONSTRAINT_CATALOG	VARCHAR(128)	The name of the catalog containing the assertion.
CONSTRAINT_SCHEMA	VARCHAR(128)	The name of the schema containing the assertion.
CONSTRAINT_NAME	VARCHAR(128)	The name of the assertion.
IS_DEFERRABLE	VARCHAR(3)	One of: YES = the assertion is deferrable NO = the assertion is not deferrable
INITIALLY_DEFERRED	VARCHAR(3)	One of: YES = the assertion is immediate NO = the assertion is deferred.

Column name	Data type	Description
CHARACTER_SET_CATALOG	VARCHAR(128)	The name of the catalog containing the character set.
CHARACTER_SET_SCHEMA	VARCHAR(128)	The name of the schema containing the character set.
CHARACTER_SET_NAME	VARCHAR(128)	The name of the character set.
FORM_OF_USE	VARCHAR(128)	A user-defined name that indicates the form-of-use of the character set.
NUMBER_OF_CHARACTERS	INTEGER	The number of characters in the character set.
DEFAULT_COLLATE_CATALOG	VARCHAR(128)	The name of the catalog containing the default collation for the character set.
DEFAULT_COLLATE_SCHEMA	VARCHAR(128)	The name of the schema containing the default collation for the character set.
DEFAULT_COLLATE_NAME	VARCHAR(128)	The name of the default collation for the character set.

Column name	Data type	Description
COLLATION_CATALOG	VARCHAR(128)	The name of the catalog containing the collation.
COLLATION_SCHEMA	VARCHAR(128)	The name of the schema containing the collation.
COLLATION_NAME	VARCHAR(128)	Name of the collation.
CHARACTER_SET_CATALOG	VARCHAR(128)	The name of the catalog containing the character set on which the collation is defined.
CHARACTER_SET_SCHEMA	VARCHAR(128)	The name of the schema containing the character set on which the collation is defined.
CHARACTER_SET_NAME	VARCHAR(128)	The name of the character set on which the collation is defined.
PAD_ATTRIBUTE	VARCHAR(20)	One of the following values: NO PAD = the collation has the no pad attribute PAD SPACE = the collation has the pad space attribute.

Column name	Data type	Description
DOMAIN_CATALOG	VARCHAR(128)	The name of the catalog containing the domain.
DOMAIN_SCHEMA	VARCHAR(128)	The name of the schema containing the domain.
DOMAIN_NAME	VARCHAR(128)	The name of the domain.
TABLE_CATALOG	VARCHAR(128)	The name of the catalog containing the table.
TABLE_SCHEMA	VARCHAR(128)	The name of the schema containing the table.
TABLE_NAME	VARCHAR(128)	The name of the table.
COLUMN_NAME	VARCHAR(128)	The name of the column.

Column name	Data type	Description
GRANTOR	VARCHAR(128)	The name of the ident who granted the privilege.
GRANTEE	VARCHAR(128)	The name of the ident to whom the privilege was granted. Granting a privilege to PUBLIC will result in only one row (per privilege granted) in this view and the name PUBLIC will be shown.
TABLE_CATALOG	VARCHAR(128)	The name of the catalog containing the table.
TABLE_SCHEMA	VARCHAR(128)	The name of the schema containing the table.
TABLE_NAME	VARCHAR(128)	The name of the table containing the column on which the column privilege has been granted.
COLUMN_NAME	VARCHAR(128)	The name of the column on which the privilege has been granted.
PRIVILEGE_TYPE	VARCHAR(20)	A value describing the type of the column privilege that was granted. One of: INSERT REFERENCES SELECT UPDATE. Note that when multiple table column privileges are granted to the same user at the same time (e.g. when the keyword ALL is used), multiple rows appear in this view (one for each privilege granted).
IS_GRANTABLE	VARCHAR(3)	One of: YES = the privilege is held WITH GRANT OPTION NO = the privilege is not held WITH GRANT OPTION.