|
|
|
|
|
|
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
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).
"NO" = the column is not nullable, according to the rules in the international standard
"YES" = the NULL value is allowed in 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.
 Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|
|
|
|
|