Class INFORMATION.SCHEMA.FOREIGNTABLES

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

SQL Table Name: FOREIGN_TABLES

This table has one row for each Foreign Table the users is privileged for in the current namespace

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
1	12				1

Summary

Properties
ClassName	Description	Owner	ParameterString
SERVERNAME	SERVERSCHEMA	TABLENAME	TABLESCHEMA
UsingString

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

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 ClassName as %String(MAXLEN=256) [ SqlFieldName = CLASSNAME,Required ];

Name of the class that projects this foreign table

• property Description as %String(MAXLEN=256) [ Calculated,SqlFieldName = DESCRIPTION ];

• property Owner as %String(MAXLEN=256) [ Calculated,SqlFieldName = OWNER ];

• property ParameterString as %String(MAXLEN=3200) [ Calculated,SqlFieldName = PARAMETERS ];

• property SERVERNAME as %String(COLLATION="Upper",MAXLEN=128) [ SqlFieldName = SERVER_NAME,Required ];

Name of the foreign server for this table.

• property SERVERSCHEMA as %String(COLLATION="Upper",MAXLEN=128) [ SqlFieldName = SERVER_SCHEMA,Required ];

Name of schema that contains the foreign server for this table

• property TABLENAME as %String(COLLATION="Upper",MAXLEN=128) [ SqlFieldName = TABLE_NAME,Required ];

Name of the foreign table.

• property TABLESCHEMA as %String(COLLATION="Upper",MAXLEN=128) [ SqlFieldName = TABLE_SCHEMA,Required ];

Name of schema that contains the foreign table.

• property UsingString as %String(MAXLEN=3200) [ Calculated,SqlFieldName = USING ];

ForeignKeys

•foreignkey FKForeignServer (ServerSchemaExact,ServerNameExact) references INFORMATION.SCHEMA.FOREIGNSERVERS () OnDelete: noaction; OnUpdate: noaction

Class Reference IRIS for UNIX 2024.1.2
Documentation Search