 |
» |
|
|
|
SYSTEM.COLDEFAULT contains detailed information
about the default constant values which have been specified
for columns, as indicated in SYSTEM.COLUMN.
While SYSTEM.COLUMN contains a row for each column in each table and
view, SYSTEM.COLDEFAULT only contains a row for each column for which
a literal default value has been specified. Default values of
NULL, USER, CURRENT_DATE, CURRENT_TIME,
or CURRENT_DATETIME do not appear in SYSTEM.COLDEFAULT; they are
indicated in SYSTEM.COLUMN by code numbers. This table is initially empty, and is updated whenever ALLBASE/SQL
processes a CREATE TABLE, DROP TABLE, or TRANSFER OWNERSHIP command
in which the column definitions use the DEFAULT Constant clause.
The source string containing the default value specification
is stored in segments of up to 64 characters. Only BINARY or
CHARACTER string columns may require more than one 64-byte segment.
All other data types can fit in a 64 byte field. Table 8-6 System.Coldefault | Column Name | Type | Length | Description |
|---|
| COLNAME | CHAR | 20 | Name of the column with a default | | TABLENAME | CHAR | 20 | Name of the table containing this column | | OWNER | CHAR | 20 | Owner of the table | | SEGNUM | SMALLINT | 2 | Segment number | | SEGLEN | SMALLINT | 2 | Length of segment in bytes | | DEFAULTVAL | CHAR | 64 | Literal value string segment
|
Example | |
SELECT * FROM System.Column;
--------------------+--------------------+--------------------+------+
COLNAME |TABLENAME |OWNER |SEGNUM|
--------------------+--------------------+--------------------+------+
COMPANY |PARTSOURCE |PURCHDB | 1|
Number of rows selected is 1
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> r
------+---------------------------------------------
SEGLEN|DEFAULTVAL
------+---------------------------------------------
22|Integrated Peripherals
Number of rows selected is 1
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
|
