Objects, keys, indices, sequences

Objects, keys, indices, sequences mk Thu, 03/28/2013 - 20:32
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 sys.key_types.key_type_id Key type id: 0=Primary Key, 1=Unique Key, 2=Foreign Key, see table sys.key_types.
"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.key_types
name type references description
"key_type_id" SMALLINT   The unique internal identifier of a key type.
"key_type_name" VARCHAR   A description of the key type.
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 sys.index_types.index_type_id The corresponding index type identifier, see table sys.index_types.
"name" VARCHAR   The SQL name.
sys.index_types
name type references description
"index_type_id" SMALLINT   The unique internal identifier of an index type.
"index_type_name" VARCHAR   A description of the index type.
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.