Skip to main content

Objects, keys, indices, sequences

SYS.OBJECTS
name type references description
"id" INTEGER   The internal object identifier.
"name" VARCHAR   The SQL name.
"nr" INTEGER   Position within the object list.
SYS.KEYS
name type references description
"id" INTEGER   The internal key identifier.
"table_id" INTEGER sys.tables.id The corresponding table identifier.
"type" INTEGER   Foreign key, primary key, uniqueness.
"name" VARCHAR   The SQL name given to the key.
"rkey" INTEGER   Related key designator.
"action" INTEGER   Cascading properties.
SYS.IDXS
name type references description
"id" INTEGER   The internal index identifier.
"table_id" INTEGER sys.tables.id The corresponding table identifier.
"type" INTEGER   The corresponding index type identifier; join-index, hash-index.
"name" VARCHAR   The SQL name.
SYS.SEQUENCES
name type references description
"id" INTEGER   The internal sequence identifier.
"schema_id" INTEGER sys.schemas.id The corresponding schema identifier.
"name" VARCHAR   The SQL name.
"start" BIGINT   The start value of the sequence.
"minvalue" BIGINT   The minimal value of the sequence.
"maxvalue" BIGINT   The maximal value of the sequence.
"increment" BIGINT   The sequence increment value.
"cacheinc" BIGINT   The increment to ease transaction management.
"cycle" BOOLEAN   The repeat the sequence upon hitting its bounds.