Returns one row for each FOREIGN KEY table constraint in the current namespace for tables that can be accessed by the current user in the current namespace. More...

Inheritance diagram for REFERENTIALCONSTRAINTS:

[legend]

Collaboration diagram for REFERENTIALCONSTRAINTS:

[legend]

Public Attributes
	CONSTRAINTCATALOG
	Catalog qualifier - always NULL in InterSystems IRIS. More...

	CONSTRAINTNAME
	Foreign key constraint name. More...

	CONSTRAINTSCHEMA
	Name of schema that contains the foreign key constraint. More...

	CONSTRAINTTABLENAME
	Name of the table that contains the foreign key constraint. More...

	DELETERULE
	The values of DELETE_RULE have the following meanings for foreign keys constraints: More...

	MATCHOPTION
	The values of MATCH_OPTION have the following meanings: More...

	UNIQUECONSTRAINTCATALOG
	Unique Constraint qualifier - always NULL in InterSystems IRIS. More...

	UNIQUECONSTRAINTNAME
	Name of the unique constraint the foreign key constraint references. More...

	UNIQUECONSTRAINTSCHEMA
	Name of the schema that contains the unique constraint the foreign key references. More...

	UNIQUECONSTRAINTTABLE
	Name of the table that contains the unique constraint the foreign key references. More...

	UPDATERULE
	The values of UPDATE_RULE have the following meanings for foreign keys constraints: More...

Additional Inherited Members
Public Member Functions inherited from Persistent
_.Library.Status	AcquireLock (_.Library.String locktype)
	Acquires a lock for the current instance. More...

_.Library.Status	LoadData (_.Library.String id)
	LoadData() - loads an object from storage. More...

_.Library.Status	OnAfterSave (_.Library.Boolean insert)
	This callback method is invoked by the <METHOD>Save</METHOD> method to. More...

_.Library.Status	OnBeforeSave (_.Library.Boolean insert)
	This callback method is invoked by the <METHOD>Save</METHOD> method to. More...

_.Library.Status	OnOpen ()
	This callback method is invoked by the <METHOD>Open</METHOD> method to. More...

_.Library.Status	OnReload ()
	This callback method is invoked by the <METHOD>Reload</METHOD> method to. More...

_.Library.Status	OnRollBack ()
	This callback method is invoked by the <METHOD>Save</METHOD> method to. More...

_.Library.Status	ReleaseLock (_.Library.String locktype)
	Releases a lock for the current instance. More...

_.Library.Status	SaveData (_.Library.String id)
	SaveData() - saves an object to disk, checks uniqueness and referential More...

Public Member Functions inherited from SwizzleObject
_.Library.Status	OnJournalObject (_.Library.Integer tranid, _.Library.Integer jrnid, _.Library.String filter)
	This callback method is invoked by the <METHOD>JournalObject</METHOD> method to. More...

Public Member Functions inherited from RegisteredObject
_.Library.Status	OnAddToSaveSet (_.Library.Integer depth, _.Library.Integer insert, _.Library.Integer callcount)
	This callback method is invoked when the current object is added to the SaveSet,. More...

_.Library.Status	OnClose ()
	This callback method is invoked by the <METHOD>Close</METHOD> method to. More...

_.Library.Status	OnConstructClone (_.Library.RegisteredObject object, _.Library.Boolean deep, _.Library.String cloned)
	This callback method is invoked by the <METHOD>ConstructClone</METHOD> method to. More...

_.Library.Status	OnNew ()
	This callback method is invoked by the <METHOD>New</METHOD> method to. More...

_.Library.Status	OnValidateObject ()
	This callback method is invoked by the <METHOD>ValidateObject</METHOD> method to. More...

Static Public Member Functions inherited from Persistent
_.Library.Status	DeleteData (_.Library.String id, _.Library.Integer concurrency)
	This method is normally generated by the storage class for persistent classes using. More...

_.Library.Status	KillExtentData (_.Library.Boolean killstreams)
	KillExtentData() - kills extent data in storage. More...

_.Library.Status	OnAfterBuildIndices (_.Library.String indexlist)
	This callback method is invoked by the <METHOD>BuildIndices</METHOD> method after all work is completed. More...

_.Library.Status	OnAfterDelete (_.Library.ObjectIdentity oid)
	This callback method is invoked by the <METHOD>Delete</METHOD> method to. More...

_.Library.Status	OnAfterPurgeIndices (_.Library.String indexlist)
	This callback method is invoked by the <METHOD>PurgeIndices</METHOD> method after all work is completed. More...

_.Library.Status	OnBeforeBuildIndices (_.Library.String indexlist)

_.Library.Status	OnBeforePurgeIndices (_.Library.String indexlist)

_.Library.Status	OnDelete (_.Library.ObjectIdentity oid)
	This callback method is invoked by the <METHOD>Delete</METHOD> method to. More...

Static Public Attributes inherited from Persistent
	XCOMPACTANCESTRY
	XCOMPACTANCESTRY can be set to a string to replace the value of the %CLASSNAME property (x__classname field) More...

	DATALOCATIONGLOBAL = None
	Global name containing master map data for this class. More...

	DEFAULTGLOBAL = None

	DSCONDITION = None
	DSCONDITION is the expression that will be evaluated before deciding whether certain actions must be taken. More...

	DSINTERVAL = None
	DSINTERVAL is the number of seconds between one DSTIME value and the next. More...

	DSTIME = None
	If the DSTIME parameter is set to AUTO then the most recent filing operation in the current DSTIME value. More...

	EXTENTQUERYSPEC = None
	The EXTENTQUERYSPEC parameter defines the properties to be retrieved in. More...

	EXTENTSIZE = None
	The EXTENTSIZE parameter is used to inform the SQL Query Optimizer More...

	GUIDENABLED = None
	If this parameter is set to 1 then a GUID will be assigned (to the GUID property) to each new object. More...

	IDENTIFIEDBY = None
	The IDENTIFIEDBY parameter can optionally be set to the name. More...

	MANAGEDEXTENT = None
	The MANAGEDEXTENT parameter can be set to 0 (zero) to cause the Extent Manager. More...

	READONLY = None
	READONLY = 1 means that objects can be created, opened but not saved or deleted. More...

	ROWLEVELSECURITY = None
	ROWLEVELSECURITY = 1 \| <property> means that row level security is active and the list More...

	SQLPREVENTFULLSCAN = None
	SQLPREVENTFULLSCAN = 1 means an attempt to prepare a query that will result in a full scan More...

	STORAGEDEFAULT = None
	STORAGEDEFAULT defines the default storage allocation to use for properties in this class. More...

	USEEXTENTSET = None

	VERSIONCLIENTNAME = None
	VERSIONCLIENTNAME can be set to a valid CLIENTNAME (see property CLIENTNAME) value. More...

	VERSIONPROPERTY = None
	VERSIONPROPERTY = <property> means that the <property> in memory will be compared to. More...

Static Public Attributes inherited from SwizzleObject
	DEFAULTCONCURRENCY = None
	DEFAULTCONCURRENCY is the default value for the concurrency formal argument. More...

	JOURNALSTREAM = None
	If OBJJOURNAL is true then the value of the JOURNALSTREAM parameter defines whether or not. More...

	OBJJOURNAL = None
	if OBJJOURNAL is TRUE then inserts, updates and deletes will be logged in ^OBJ.JournalT More...

Static Public Attributes inherited from RegisteredObject
	CAPTION = None
	Optional name used by the Form Wizard for a class when generating forms. More...

	JAVATYPE = None
	The Java type to be used when exported.

	PROPERTYVALIDATION = None
	This parameter controls the default validation behavior for the object. More...

Detailed Description

Returns one row for each FOREIGN KEY table constraint in the current namespace for tables that can be accessed by the current user in the current namespace.

The REFERENTIAL_CONSTRAINTS table has one row for each row in the TABLE_CONSTRAINTS table that has a CONSTRAINT_TYPE value of "FOREIGN KEY".

Member Data Documentation

◆ CONSTRAINTCATALOG

CONSTRAINTCATALOG

Catalog qualifier - always NULL in InterSystems IRIS.

◆ CONSTRAINTNAME

CONSTRAINTNAME

Foreign key constraint name.

◆ CONSTRAINTSCHEMA

CONSTRAINTSCHEMA

Name of schema that contains the foreign key constraint.

◆ CONSTRAINTTABLENAME

CONSTRAINTTABLENAME

Name of the table that contains the foreign key constraint.

◆ DELETERULE

DELETERULE

The values of DELETE_RULE have the following meanings for foreign keys constraints:

NO ACTION - A referential action of NO ACTION was specified.
SET NULL - A referential action of SET NULL was specified.
SET DEFAULT - A referential action of SET DEFAULT was specified.
RESTRICT - A referential action of RESTRICT was specified.
CASCADE - A referential action of CASCADE was specified.

◆ MATCHOPTION

MATCHOPTION

The values of MATCH_OPTION have the following meanings:

NONE - No match type was specified.
PARTIAL - A match type of partial was specified.
FULL - A match type of full was specified.

For InterSystems IRIS MATCH_OPTION is always NONE.

◆ UNIQUECONSTRAINTCATALOG

UNIQUECONSTRAINTCATALOG

Unique Constraint qualifier - always NULL in InterSystems IRIS.

◆ UNIQUECONSTRAINTNAME

UNIQUECONSTRAINTNAME

Name of the unique constraint the foreign key constraint references.

◆ UNIQUECONSTRAINTSCHEMA

UNIQUECONSTRAINTSCHEMA

Name of the schema that contains the unique constraint the foreign key references.

◆ UNIQUECONSTRAINTTABLE

UNIQUECONSTRAINTTABLE

Name of the table that contains the unique constraint the foreign key references.

◆ UPDATERULE

UPDATERULE

The values of UPDATE_RULE have the following meanings for foreign keys constraints:

NO ACTION - A referential action of NO ACTION was specified.
SET NULL - A referential action of SET NULL was specified.
SET DEFAULT - A referential action of SET DEFAULT was specified.
RESTRICT - A referential action of RESTRICT was specified.
CASCADE - A referential action of CASCADE was specified.

Public Attributes

Additional Inherited Members