| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| SCHEMA |
CHAR(8) NOT NULL |
The value of TBCREATOR from the SYSCOLUMNS entry for the identity column. |
G |
| OWNER |
CHAR(8) NOT NULL |
The value of TBCREATOR from the SYSCOLUMNS entry for the identity column. |
G |
| NAME |
CHAR(18) NOT NULL |
Name that DB2 generated for the identity column. |
G |
| SEQTYPE |
CHAR(1) NOT NULL |
Type of entry:
I For an identity column |
G |
| SEQUENCEID |
INTEGER NOT NULL |
Internal identifier of the identity column. |
G |
| CREATEDBY |
CHAR(8) NOT NULL |
The authorization ID under which the identity column was created. |
G |
| INCREMENT |
DECIMAL(31,0) NOT NULL |
Increment value (positive or negative, within INTEGER scope). |
G |
| START |
DECIMAL(31,0) NOT NULL |
Start value. |
G |
| MAXVALUE |
DECIMAL(31,0) NOT NULL |
Maximum value allowed for the identity column. |
G |
| MINVALUE |
DECIMAL(31,0) NOT NULL |
Minimum value allowed for the identity column. |
G |
| CYCLE |
CHAR(1) NOT NULL |
Whether values for the identity column are wrapped (values continue to be
generated for the column after the maximum or minimum value is reached):
N No
Y Yes |
G |
| CACHE |
INTEGER NOT NULL |
Number of identity column values to preallocate in memory for faster access. A
value of 0 indicates that values are not to be preallocated. |
G |
| ORDER |
CHAR(1) NOT NULL |
The value is always 'N' for an identity column. |
G |
| DATATYPEID |
INTEGER NOT NULL |
For a built-in data type, the internal ID of the built-in type. For a distinct type, the
internal ID of the distinct type. |
S |
| SOURCETYPEID |
INTEGER NOT NULL |
For a built-in data type, 0. For a distinct type, the internal ID of the built-in data
type upon which the distinct type is sourced. |
S |
| CREATEDTS |
TIMESTAMP NOT NULL |
Timestamp when the identity column was created. |
G |
| ALTEREDTS |
TIMESTAMP NOT NULL |
Timestamp when the identity column was created. |
G |
| MAXASSIGNEDVAL |
DECIMAL(31,0) |
Last possible assigned value. Initialized to null when the sequence object is
created. Updated each time the next chunk of n values is cached, where n is the
value for CACHE. |
G |
| IBMREQD |
CHAR(1) NOT NULL |
A value of Y indicates that the row came from the basic machine-readable material
(MRM) tape. For all other values, see Release dependency indicators in topic D.0. |
G |
| REMARKS |
VARCHAR(254) NOT NULL |
The value is always blank for an identity column. |
G |
