persistent class %TSQL.sys.keys
extends %Persistent
contains one row for each primary, foreign, or common key.
• parameter READONLY = 1;
READONLY = 1 means that objects can be created, opened but not saved or deleted.
Tables are projected to SQL as READONLY.
• property constrid
as %Integer [ SqlFieldName = constr_id ];
Object ID of the constraint this key belongs to
• property id
as %Integer;
Object ID of the table this key belongs to
• property key1
as %Integer;
Column ID
• property key2
as %Integer;
Column ID
• property key3
as %Integer;
Column ID
• property key4
as %Integer;
Column ID
• property key5
as %Integer;
Column ID
• property key6
as %Integer;
Column ID
• property key7
as %Integer;
Column ID
• property key8
as %Integer;
Column ID
• property keycnt
as %Integer;
Number of non-NULL keys
• property parentobjname
as %String(MAXLEN=128) [ SqlFieldName = parent_obj_name ];
Parent Object name
Object name of the parent_obj.
• property schema
as %String(MAXLEN=128);
Name of the schema the column resides in
• property type
as %SmallInt;
Record type
•index (IDKEYIndex on id,constrid) [IdKey,Unique];
