Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


COLUMNS


The COLUMNS system view lists the table columns that the current ident is privileged to access.

If the current ident, or PUBLIC, holds one or more of INSERT, DELETE or SELECT privilege on a table, then one row is shown for each column in the table.

If the current ident, or PUBLIC, holds REFERENCES or UPDATE privilege on one or more table columns, then one row is shown for each of the columns.

Column name
Data type
Description
TABLE_CAT
VARCHAR(128)
The name of the catalog containing the table or view.
TABLE_SCHEM
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_DEF
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 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_DEF 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
CHARACTER
CHARACTER VARYING
DATE
DECIMAL
DOUBLE PRECISION
FLOAT
INTEGER
INTERVAL
NUMERIC
REAL
SMALLINT
TIME
TIMESTAMP.
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).
NUM_PREC
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. NUM_PREC_RADIX indicates the units of measurement.
NUM_PREC_RADIX
INTEGER
For numeric data types, the value 10 is shown because NUM_PREC specifies a number of decimal digits. For all other data types it is the NULL value. NUM_PREC and NUM_PREC_RADIX can be combined to calculate the maximum number that the column can hold.
NUM_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.
DATETIME_PREC
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 Named Interval Data Types). For other data types it is the NULL value.
INTERVAL_PREC
INTEGER
For interval data types, this is the number of significant digits for the interval leading precision (see Named Interval Data Types). For other data types it is the NULL value.
CHAR_SET_CAT
VARCHAR(128)
The name of the catalog containing the character set used by the column.
CHAR_SET_SCHEM
VARCHAR(128)
The name of the schema containing the character set used by the column.
CHAR_SET_NAME
VARCHAR(128)
The name of the character set used by the column.
COLLATION_CAT
VARCHAR(128)
The name of the catalog containing the collation used by the column.
COLLATION_SCHEM
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_CAT
VARCHAR(128)
The name of the catalog containing the domain used by the column.
DOMAIN_SCHEM
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.
REMARKS
VARCHAR(254)
May contain descriptive information about the column.



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