This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Home > Class Reference > %SYS namespace > INFORMATION.SCHEMA.CHECKCONSTRAINTS

INFORMATION.SCHEMA.CHECKCONSTRAINTS

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

SQL Table Name: INFORMATION_SCHEMA.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 Caché does not currently support check constraints, this table exists for future use.

Property Inventory (Including Private)

Parameters

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

Properties (Including Private)

property CHECKCLAUSE as %String (MAXLEN = 2048) [ Calculated , SqlFieldName = CHECK_CLAUSE ];
The search condition contained in the check constraint definition.
Property methods: CHECKCLAUSECompute(), CHECKCLAUSEDisplayToLogical(), CHECKCLAUSEGet(), CHECKCLAUSEIsValid(), CHECKCLAUSELogicalToDisplay(), CHECKCLAUSELogicalToOdbc(), CHECKCLAUSENormalize(), CHECKCLAUSESQLCompute()
property CONSTRAINTCATALOG as %String (MAXLEN = 128) [ Calculated , SqlFieldName = CONSTRAINT_CATALOG ];
Constraint qualifier - always NULL in Caché.
Property methods: CONSTRAINTCATALOGCompute(), CONSTRAINTCATALOGDisplayToLogical(), CONSTRAINTCATALOGGet(), CONSTRAINTCATALOGIsValid(), CONSTRAINTCATALOGLogicalToDisplay(), CONSTRAINTCATALOGLogicalToOdbc(), CONSTRAINTCATALOGNormalize(), CONSTRAINTCATALOGSQLCompute()
property CONSTRAINTNAME as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = CONSTRAINT_NAME ];
Name of the constraint.
Property methods: CONSTRAINTNAMEDisplayToLogical(), CONSTRAINTNAMEGet(), CONSTRAINTNAMEIsValid(), CONSTRAINTNAMELogicalToDisplay(), CONSTRAINTNAMELogicalToOdbc(), CONSTRAINTNAMENormalize(), CONSTRAINTNAMESet()
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.
Property methods: CONSTRAINTSCHEMADisplayToLogical(), CONSTRAINTSCHEMAGet(), CONSTRAINTSCHEMAIsValid(), CONSTRAINTSCHEMALogicalToDisplay(), CONSTRAINTSCHEMALogicalToOdbc(), CONSTRAINTSCHEMANormalize(), CONSTRAINTSCHEMASet()

Inherited Members

Inherited Methods (Including Private)

Storage

Gray indicates storage defined by superclasses.

Storage Model: CacheSQLStorage

Maps: 2

FeedbackOpens in a new window