SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
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.
TBL_CONSTRAINTS Table
TBL_CONSTRAINTS is a metadata table in
DEFINITION_SCHEMA_VERSION_vernum that contains one entry for each unique,
primary key, foreign, or check constraint on a table in the catalog:
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
Column Name Data Type Description
*1 CONSTRAINT_UID LARGEINT UID of constraint
*2 CONSTRAINT_TYPE CHAR(2) Constraint type:
C Check
F Foreign
P Primary key
U Unique
*3 TABLE_UID LARGEINT UID of table
4 DISABLED CHAR(2) Y if not enforced
N if enforced
5 DROPPABLE CHAR(2) Y if user can drop
N if user cannot drop
6 IS_DEFERRABLE CHAR(2) Reserved for future use
7 INITIALLY_DEFERRABLE CHAR(2) Reserved for future use
8 INDEX_UID LARGEINT If an index supports this constraint, UID
of index; otherwise 0 (zero)