Skip to main content

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

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

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

Storage

Gray indicates storage defined by superclasses.

Storage Model: CacheSQLStorage

Maps: 2

  • Map number 1 is named Master

    thismap.Global: ^oddSQL

  • Map number 2 is named rxIndex

    thismap.Global: ^rINDEXSQL

  • ^oddSQL({SchemaExact},{TableExact},15,{ConstraintExact})
    =
    Node Delimiter Piece Name
    TableName
    ^rINDEXSQL("rv",$$UPPER({CONSTRAINT_SCHEMA}),$$UPPER({TableName}),{ConstraintExact})
    =
    Node Delimiter Piece Name
    TableExact
FeedbackOpens in a new tab