SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-29
SG_USAGE Table
SG_USAGE Table
SG_USAGE is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that
represents the usage of Sequence Generator objects by other objects.
Each SG_USAGE row links a base table with an IDENTITY column to the associated
internal Sequence Generator.
9 CYCLE_OPTION CHAR(2) Y/N indication if the
CYCLE option is used
10 CACHE NUMERIC(128,
0)
Reserved for future use
11 SG_ORDER CHAR(2) Reserved for future use
12 EXTENDED_PRECIS
ION
INTEGER Reserved for future use
* Indiates
primary
key
Column number Column Name Data Type Description
*1 SG_OBJECT_UID LARGEINT Object UID of used SG
object
*2 USING_OBJECT_OB
J_UID
LARGEINT Object UID of using object
*3 SG_CAT_UID LARGEINT Catalog UID of used SG
object
*4 USING_OBJECT_CA
T_UID
LARGEINT Catalog UID of using
object
5 SG_SCH_UID LARGEINT Schema UID of used SG
object
6 USING_OBJECT_SC
H_UID
LARGEINT Schema UID of using
object
* Indicates primary key