Skip to main content

%TSQL.sys.keys

Class %TSQL.sys.keys Extends %Persistent [ SqlRowIdPrivate, StorageStrategy = SQLStorage, System = 4 ]

contains one row for each primary, foreign, or common key.

Parameters​

READONLY​

Parameter READONLY = 1;

Properties​

schema​

Property schema As %String(MAXLEN = 128) [ SqlColumnNumber = 13 ];

Name of the schema the column resides in

parentobjname​

Property parentobjname As %String(MAXLEN = 128) [ SqlColumnNumber = 14, SqlFieldName = parent_obj_name ];

Parent Object name Object name of the parent_obj.

keycnt​

Property keycnt As %Integer [ SqlColumnNumber = 4 ];

Number of non-NULL keys

key1​

Property key1 As %Integer [ SqlColumnNumber = 5 ];

Column ID

key2​

Property key2 As %Integer [ SqlColumnNumber = 6 ];

Column ID

key3​

Property key3 As %Integer [ SqlColumnNumber = 7 ];

Column ID

key4​

Property key4 As %Integer [ SqlColumnNumber = 8 ];

Column ID

key5​

Property key5 As %Integer [ SqlColumnNumber = 9 ];

Column ID

key6​

Property key6 As %Integer [ SqlColumnNumber = 10 ];

Column ID

key7​

Property key7 As %Integer [ SqlColumnNumber = 11 ];

Column ID

key8​

Property key8 As %Integer [ SqlColumnNumber = 12 ];

Column ID

id​

Property id As %Integer [ SqlColumnNumber = 2 ];

Object ID of the table this key belongs to

constrid​

Property constrid As %Integer [ SqlColumnNumber = 15, SqlFieldName = constr_id ];

Object ID of the constraint this key belongs to

type​

Property type As %SmallInt [ SqlColumnNumber = 3 ];

Record type