Download Mimer SQL Reference Manual - Department of Information Technology

Data dictionary views
7-27
NUMERIC_SCALE
INTEGER
This defines the total number of significant
digits to the right of the decimal point. For
BIGINT, INTEGER and SMALLINT, this is 0.
For BINARY, BINARY VARYING,
CHARACTER, CHARACTER VARYING,
DATETIME, FLOAT, INTERVAL, REAL and
DOUBLE PRECISION 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(128) For interval data types, this is a character string
specifying the interval qualifier for the named
interval data type (see Section 4.3.3.2).
INTERVAL_PRECISION
INTEGER
For interval data types, this is the number of
significant digits for the interval leading
precision (see Section 4.3.3.2).
REFERENTIAL_CONSTRAINTS
The REFERENTIAL_CONSTRAINTS system view lists the referential
constraints that are accessible by the current ident.
Column name
Data type
Description
CONSTRAINT
_CATALOG
VARCHAR(128) The name of the catalog containing the
referential constraint.
CONSTRAINT_SCHEMA
VARCHAR(128) The name of the schema containing the
referential constraint.
CONSTRAINT_NAME
VARCHAR(128) The name of the referential constraint.
UNIQUE_CONSTRAINT
_CATALOG
VARCHAR(128) The name of the catalog containing the unique
constraint being referenced.
UNIQUE_CONSTRAINT
_SCHEMA
VARCHAR(128) The name of the schema containing the unique
constraint being referenced
UNIQUE_CONSTRAINT
_NAME
VARCHAR(128) The name of the unique constraint being
referenced.
MATCH_OPTION
VARCHAR(20)
One of:
NONE
PARTIAL
FULL.
UPDATE_RULE
VARCHAR(20)
One of:
CASCADE
SET NULL
SET DEFAULT
NO ACTION.
DELETE_RULE
VARCHAR(20)
One of:
CASCADE
SET NULL
SET DEFAULT
NO ACTION.
Mimer SQL version 8.2
Reference Manual