Skip to main content

%TSQL.sys.constraints

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

Contains one row for every column in every table and view, and a row for each parameter in a stored procedure.

Parameters​

READONLY​

Parameter READONLY = 1;

Properties​

schema​

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

Name of the schema the column resides in

parentobjname​

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

Parent Object name Object name of the parent_obj.

constrid​

Property constrid As %Integer [ SqlColumnNumber = 3 ];

Object ID of the constraint

colid​

Property colid As %TinyInt [ SqlColumnNumber = 2 ];

Column number in the table

tableid​

Property tableid As %Integer [ SqlColumnNumber = 4 ];

ID of the table on which the constraint is declared

status​

Property status As %Integer [ SqlColumnNumber = 6 ];

The type of constraint: 0x0040 = a referential constraint 0x0080 = a check constraint