Class Reference
IRIS for UNIX 2019.2
InterSystems: The power behind what matters   
Documentation  Search
  [%SYS] >  [INFORMATION] >  [SCHEMA] >  [CONSTRAINTCOLUMNUSAGE]
Private  Storage   

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

SQL Table Name: CONSTRAINT_COLUMN_USAGE

Returns one row for each column for each CHECK, UNIQUE, PRIMARY KEY, FOREIGN KEY constraint, or assertion in the current namespace for tables that can be accessed by the current user in the current namespace. The rows list the columns that constitute each unique constraint, and the referencing columns in each foreign key constraint. Since InterSystems IRIS does not currently support CHECK constraints or assertions, CONSTRAINT_COLUMN_USAGE returns the same rows as KEY_COLUMN_USAGE

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
1 12 2


Summary

Properties
COLUMNNAME CONSTRAINTCATALOG CONSTRAINTNAME CONSTRAINTSCHEMA
TABLECATALOG TABLENAME TABLESCHEMA

Methods
%AddToSaveSet %AddToSyncSet %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 %OnDetermineClass
%Open %OpenId %OriginalNamespace %PackageName
%PurgeIndices %Reload %RemoveFromSaveSet %ResolveConcurrencyConflict
%RollBack %Save %SaveDirect %SerializeObject
%SetModified %SortBegin %SortEnd %SyncObjectIn
%SyncTransport %UnlockExtent %UnlockId %ValidateIndices
%ValidateObject


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 COLUMNNAME as %String(COLLATION="Upper",MAXLEN=128) [ SqlFieldName = COLUMN_NAME,Required ];
Name of the column.
• property CONSTRAINTCATALOG as %String(MAXLEN=128) [ Calculated,SqlFieldName = CONSTRAINT_CATALOG ];
Table 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) [ Calculated,SqlFieldName = CONSTRAINT_SCHEMA ];
Name of schema that contains the constraint. Always the same as the TABLE_SCHEMA.
• property TABLECATALOG as %String(MAXLEN=128) [ Calculated,SqlFieldName = TABLE_CATALOG ];
Table qualifier - always NULL in InterSystems IRIS.
• property TABLENAME as %String(COLLATION="Upper",MAXLEN=128) [ SqlFieldName = TABLE_NAME,Required ];
Name of the table.
• property TABLESCHEMA as %String(COLLATION="Upper",MAXLEN=128) [ SqlFieldName = TABLE_SCHEMA,Required ];
Name of schema that contains the table.

Indices

•index (PKeyIndex on TABLESCHEMA,TABLENAME,CONSTRAINTNAME,COLUMNNAME) [PrimaryKey];


Copyright (c) 2019 by InterSystems Corporation. Cambridge, Massachusetts, U.S.A. All rights reserved. Confidential property of InterSystems Corporation.