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 InterSystems IRIS 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 InterSystems IRIS.
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: SQLStorage

Maps: 2

Feedback