Skip to main content

Objects, keys, indices, sequences

sys.objects
name type references description
"id" INTEGER   The internal object identifier. Primary key of this table is the combination of "id" and "nr".
"name" VARCHAR   The SQL name.
"nr" INTEGER   Position within the object list.
sys.keys
name type references description
"id" INTEGER sys.objects.id The unique internal key identifier.
"table_id" INTEGER sys.tables.id The corresponding table identifier.
"type" INTEGER   Key type: 0=Primary Key, 1=Unique Key, 2=Foreign Key.
"name" VARCHAR   The SQL name given to the key.
"rkey" INTEGER   Related key designator. -1 if not applicable.
"action" INTEGER   Cascading properties. -1 if not applicable.
sys.idxs
name type references description
"id" INTEGER sys.objects.id The unique 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 unique 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.