Skip to main content

INFORMATION.SCHEMA.CHECKCONSTRAINTS

Class INFORMATION.SCHEMA.CHECKCONSTRAINTS Extends %Library.Persistent [ ClassType = persistent, Final, Owner = {_PUBLIC}, SqlRowIdPrivate, SqlTableName = CHECK_CONSTRAINTS, StorageStrategy = SQLStorage, System = 4 ]

Returns one row for each check constraint in the current namespace for tables that can be accessed by the current user in the current namespace. Note that InterSystems IRIS does not currently support check constraints, this table exists for future use.

Parameters​

READONLY​

Parameter READONLY = 1;

Properties​

SchemaExact​

Property SchemaExact As %String(MAXLEN = 128) [ Internal, Private, Required, SqlColumnNumber = 10 ];

TableExact​

Property TableExact As %String(MAXLEN = 128) [ Internal, Private, Required, SqlColumnNumber = 11 ];

TableName​

Property TableName As %String(COLLATION = "Upper", MAXLEN = 128) [ Internal, Private, Required, SqlColumnNumber = 12 ];

ConstraintExact​

Property ConstraintExact As %String(MAXLEN = 128) [ Internal, Private, Required, SqlColumnNumber = 13 ];

SystemTable​

Property SystemTable As %Integer [ Calculated, Internal, Private, Required, SqlColumnNumber = 14, SqlComputeCode = { set {*}=$s($e({CONSTRAINT_SCHEMA})="%"||({CONSTRAINT_SCHEMA}="INFORMATION_SCHEMA"):1,1:0) }, SqlComputed ];

Is the table a system table (1 or 0)

CONSTRAINTCATALOG​

Property CONSTRAINTCATALOG As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 2, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = CONSTRAINT_CATALOG ];

Constraint qualifier - always NULL in InterSystems IRIS.

CONSTRAINTSCHEMA​

Property CONSTRAINTSCHEMA As %String(COLLATION = "Upper", MAXLEN = 128) [ SqlColumnNumber = 3, SqlFieldName = CONSTRAINT_SCHEMA ];

Name of schema that contains the constraint. Always the same as the TABLE_SCHEMA.

CONSTRAINTNAME​

Property CONSTRAINTNAME As %String(COLLATION = "Upper", MAXLEN = 128) [ SqlColumnNumber = 4, SqlFieldName = CONSTRAINT_NAME ];

Name of the constraint.

CHECKCLAUSE​

Property CHECKCLAUSE As %String(MAXLEN = 2048) [ Calculated, SqlColumnNumber = 5, SqlComputeCode = { set {*}="" }, SqlComputed, SqlFieldName = CHECK_CLAUSE ];

The search condition contained in the check constraint definition.