Objects, Keys, Indices, and Sequences

sys.objects

nametypereferencesdescription
"id"INTEGERThe internal object identifier. Primary key of this table is the combination of "id" and "nr".
"name"VARCHARThe SQL name.
"nr"INTEGERPosition within the object list.

sys.keys

nametypereferencesdescription
"id"INTEGERsys.objects.idThe unique internal key identifier.
"table_id"INTEGERsys.tables.idThe corresponding table identifier.
"type"INTEGERsys.key_types.key_type_idKey type id: 0=Primary Key, 1=Unique Key, 2=Foreign Key, see table sys.key_types.
"name"VARCHARThe SQL name given to the key.
"rkey"INTEGERsys.keys.id when rkey > 0Related key designator. -1 if not applicable.
"action"INTEGERFKey on UPDATE/DELETE rule action type: 0=NO ACTION, 1=CASCADE, 2=RESTRICT, 3=SET NULL, 4=SET DEFAULT. -1 if not applicable.

sys.key_types

nametypereferencesdescription
"key_type_id"SMALLINTThe unique internal identifier of a key type.
"key_type_name"VARCHARA description of the key type.

sys.idxs

nametypereferencesdescription
"id"INTEGERsys.objects.idThe unique internal index identifier.
"table_id"INTEGERsys.tables.idThe corresponding table identifier.
"type"INTEGERsys.index_types.index_type_idThe corresponding index type identifier, see table sys.index_types.
"name"VARCHARThe SQL name.

sys.idx_types

nametypereferencesdescription
"index_type_id"SMALLINTThe unique internal identifier of an index type.
"index_type_name"VARCHARA description of the index type.

sys.sequences

nametypereferencesdescription
"id"INTEGERThe unique internal sequence identifier.
"schema_id"INTEGERsys.schemas.idThe corresponding schema identifier.
"name"VARCHARThe SQL name.
"start"BIGINTThe start value of the sequence.
"minvalue"BIGINTThe minimal value of the sequence.
"maxvalue"BIGINTThe maximal value of the sequence.
"increment"BIGINTThe sequence increment value.
"cacheinc"BIGINTThe increment to ease transaction management.
"cycle"BOOLEANThe repeat the sequence upon hitting its bounds.