SYSIBM.SYSSEQUENCESDEP table

The SYSIBM.SYSSEQUENCESDEP table records the dependencies of identity columns and sequences.

Column name Data type Description Use
BSEQUENCEID
INTEGER
NOT NULL
 Internal identifier of the identity column or sequence. G
DCREATOR
VARCHAR(128)
NOT NULL
 The owner of the object that is dependent on this identity column or sequence. 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.

The value in this field is not a reliable indicator of release dependencies.

 G
DNAME
VARCHAR(128)
NOT NULL
 Name of the object that is dependent on this identity column or sequence. G
DCOLNAME
VARCHAR(128)
NOT NULL
 Name of the identity column. Blank for SQL function rows. G
DTYPE
CHAR(1)
NOT NULL
WITH DEFAULT
'I'
 The type of object that is dependent on this sequence:
F
SQL function
I
Identity column
X
Implicit DOCID column that is created on a base table with XML
blank
Represents an identity column created prior to Version 8
 G
BSCHEMA
VARCHAR(128)
NOT NULL WITH
DEFAULT
 The schema name of the sequence, will be a string of length zero for an object created prior to Version 8. G
BNAME
VARCHAR(128)
NOT NULL WITH
DEFAULT
 The sequence name (generated by DB2® for an identity column), will be a string of length zero for an object created prior to Version 8. G
DSCHEMA
VARCHAR(128)
NOT NULL WITH
DEFAULT
 The qualifier of the object that is dependent on this sequence, will be a string of length zero for an object created prior to Version 8. G
DOWNER
VARCHAR(128)
NOT NULL WITH
DEFAULT
 The owner of the object that is dependent on this sequence. This will be a string of length zero for an object that was created prior to Version 9. G
DOWNERTYPE
CHAR(1)
NOT NULL WITH
DEFAULT
 The type of owner:
Blank
An authorization ID
L
A role
 G