www.mimer.com/developer

COLUMNS

---

The COLUMNS system view lists the table columns to which the current ident, or PUBLIC, 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	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.
CHARACTER _MAXIMUM_LENGTH	INTEGER	For a character data type, this shows the maximum length in characters. For all other data types it is the NULL value.
CHARACTER _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 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	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(30)	For interval data types, this is a character string specifying the interval qualifier. For other data types it is the NULL value. 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".
INTERVAL_PRECISION	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.
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.

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se