Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


COLUMNS


Records table and view columns in the database.

Column name
Data type
Description

TABLE_SYSID

INTEGER

System identifier for the table or view.

COLUMN_NAME

VARCHAR(128)

The name of the table or view column.

ORDINAL_POSITION

INTEGER

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

DOMAIN_SYSID

INTEGER

System identifier for the domain used by the column.

COLLATION_SYSID

INTEGER

System identifier for the collation used by the column.

DATA_TYPE

CHAR(30)

Identifies the data type of the column.
Can be one of the following:
"BIGINT"
"BINARY"
"BINARY VARYING"
"CHARACTER"
"CHARACTER VARYING"
"DATE"
"DECIMAL"
"DOUBLE PRECISION"
"FLOAT"
"INTEGER"
"INTERVAL"
"NUMERIC"
"REAL"
"SMALLINT"
"TIME"
"TIMESTAMP".

INTERVAL_TYPE

CHAR(30)

For interval data types, this is a character string specifying the interval qualifier for the named interval data type, see the Mimer SQL Reference Manual.
For other data types it is the NULL value.

CHAR_MAX_LENGTH

INTEGER

For a character data type, this shows the maximum length in characters.
For all other data types it is the NULL value.

CHAR_OCTET_LENGTH

INTEGER

For a character data type, 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 CHAR_MAX_LENGTH).

NUMERIC_PRECISION

INTEGER

For numeric data types, this shows the total number of decimal digits allowed in the column. For all other data types it is the NULL value. NUMERIC_PREC_RADIX indicates the units of measurement.

NUMERIC_SCALE

INTEGER

This defines the total number of significant digits to the right of the decimal point. For INTEGER and SMALLINT, this is 0. For CHARACTER, CHARACTER VARYING, DATETIME, FLOAT, INTERVAL, REAL and DOUBLE PRECISION data types, it is the NULL value.

NUMERIC_PREC_RADIX

INTEGER

For numeric data types, the value 10 is shown because NUMERIC_PRECISION specifies a number of decimal digits. For all other data types it is the NULL value. NUMERIC_PRECISION and NUMERIC_PREC_RADIX can be combined to calculate the maximum number that the column can hold.

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_PRECISION

INTEGER

For interval data types, this is the number of significant digits for the interval leading precision, see the Mimer SQL Reference Manual.
For other data types it is the NULL value.

IS_NULLABLE

CHAR(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.

IS_UPDATABLE

CHAR(3)

One of:
"NO" = the column is not updatable
"YES" = the column is updatable.

IS_INSTEAD_OF

CHAR(3)

One of:
"NO"
"YES".

INTERNAL_LENGTH

INTEGER

Length in bytes of value.

INTERNAL_OFFSET

INTEGER

Offset for value in record.

INTERNAL_VC_OFFSET

INTEGER

Offset for field containing actual length for a varying length item.

COLUMN_CARD

BIGINT

Number of unique values in column.

COLUMN_CARD_NONULL

BIGINT

Number of values in column that are not null.

COLUMN_LOW_VALUE

CHAR(16)

Lowest value in column.

COLUMN_HIGH_VALUE

CHAR(16)

Highest value in column.

COLUMN_DEFAULT

VARCHAR(2000)

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 the Mimer SQL Reference Manual 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 and the text will be stored in the SOURCE_DEFINITION table.
If no default value was specified then its value is the NULL value.
The value of COLUMN_DEF is syntactically suitable for use in specifying default-value in a CREATE TABLE or ALTER TABLE statement.

REMARKS

VARCHAR(254)

A comment on the column. If no comment has been defined a zero length string is stored.

Primary key: TABLE_SYSID, COLUMN_NAME

Unique constraint: TABLE_SYSID, ORDINAL_POSITION

Unique constraint: TABLE_SYSID, INTERNAL_OFFSET



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL System Management Handbook TOC PREV NEXT INDEX