Class INFORMATION.SCHEMA.CHECKCONSTRAINTS

persistent class INFORMATION.SCHEMA.CHECKCONSTRAINTS extends %Library.Persistent

SQL Table Name: CHECK_CONSTRAINTS

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.

Inventory

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
1	9

Summary

Properties
CHECKCLAUSE	CONSTRAINTCATALOG	CONSTRAINTNAME	CONSTRAINTSCHEMA

Methods
%AddToSaveSet	%AddToSyncSet	%BuildDeferredIndices	%BuildIndicesAsync
%BuildIndicesAsyncResponse	%CheckConstraints	%CheckConstraintsForExtent	%ClassIsLatestVersion
%ClassName	%ComposeOid	%ConstructClone	%Delete
%DeleteExtent	%DeleteId	%DispatchClassMethod	%DispatchGetModified
%DispatchGetProperty	%DispatchMethod	%DispatchSetModified	%DispatchSetMultidimProperty
%DispatchSetProperty	%Exists	%ExistsId	%Extends
%GUID	%GUIDSet	%GetLock	%GetParameter
%GetSwizzleObject	%Id	%IsA	%IsModified
%IsNull	%KillExtent	%LockExtent	%LockId
%New	%NormalizeObject	%ObjectIsNull	%ObjectModified
%Oid	%OnBeforeAddToSync	%OnDeleteFinally	%OnDetermineClass
%OnOpenFinally	%OnSaveFinally	%Open	%OpenId
%OriginalNamespace	%PackageName	%PurgeIndices	%Reload
%RemoveFromSaveSet	%ResolveConcurrencyConflict	%RollBack	%Save
%SaveDirect	%SerializeObject	%SetModified	%SortBegin
%SortEnd	%SyncObjectIn	%SyncTransport	%UnlockExtent
%UnlockId	%ValidateIndices	%ValidateObject	%ValidateTable

Parameters

• parameter READONLY = 1;

READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Properties

• property CHECKCLAUSE as %String(MAXLEN=2048) [ Calculated,SqlFieldName = CHECK_CLAUSE ];

The search condition contained in the check constraint definition.

• property CONSTRAINTCATALOG as %String(MAXLEN=128) [ Calculated,SqlFieldName = CONSTRAINT_CATALOG ];

Constraint qualifier - always NULL in InterSystems IRIS.

• property CONSTRAINTNAME as %String(COLLATION="Upper",MAXLEN=128) [ SqlFieldName = CONSTRAINT_NAME ];

Name of the constraint.

• property CONSTRAINTSCHEMA as %String(COLLATION="Upper",MAXLEN=128) [ SqlFieldName = CONSTRAINT_SCHEMA ];

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

Class Reference IRIS for UNIX 2024.1.2
Documentation Search