INFORMATION.SCHEMA.VIEWTABLEUSAGE


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

SQL Table Name: VIEW_TABLE_USAGE

Returns one row for each table in the current namespace where the table is used by a view, and the current user has privileges for the table and view.

Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers
1 10 2


Summary


Properties
TABLECATOLOG TABLENAME TABLESCHEMA VIEWCATALOG VIEWNAME
VIEWSCHEMA

Methods
%AddToSaveSet %AddToSyncSet %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 %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 TABLECATOLOG 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.
• property VIEWCATALOG as %String(MAXLEN=128) [ Calculated,SqlFieldName = VIEW_CATALOG ];
View qualifier - always NULL in InterSystems IRIS.
• property VIEWNAME as %String(COLLATION="Upper",MAXLEN=128) [ SqlFieldName = VIEW_NAME,Required ];
Name of the view.
• property VIEWSCHEMA as %String(COLLATION="Upper",MAXLEN=128) [ SqlFieldName = VIEW_SCHEMA,Required ];
Name of schema that contains the view.

Indices


•index (PKeyIndex on VIEWSCHEMA,VIEWNAME,TABLESCHEMA,TABLENAME) [PrimaryKey];
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA