Class INFORMATION.SCHEMA.VIEWS

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

SQL Table Name: VIEWS

Returns one row for each view in the current namespace for which the current user has privileges

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
1	18

Summary

Properties
CHECKOPTION	Classname	DATECREATED	DATEMODIFIED
DESCRIPTION	ISTRIGGERDELETABLE	ISTRIGGERINSERTABLEINTO	ISTRIGGERUPDATABLE
ISUPDATABLE	Owner	Queryname	TABLECATALOG
TABLENAME	TABLESCHEMA	VIEWDEFINITION

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 CHECKOPTION as %String(MAXLEN=8,VALUELIST=",CASCADED,LOCAL,NONE") [ Calculated,SqlFieldName = CHECK_OPTION ];

The view's check option setting.
Values of CHECK_OPTION have the following meanings:

CASCADED - The view has the CASCADED check option specified.

LOCAL - The view has the LOCAL check option specified.

NONE - The view has no check option specified.

• property Classname as %String(MAXLEN=254) [ Calculated,SqlFieldName = CLASSNAME ];

Name of the class that projected the view definition

• property DATECREATED as %TimeStamp [ Calculated,SqlFieldName = DATE_CREATED ];

Timestamp for when the class projecting the view definition was created.

• property DATEMODIFIED as %TimeStamp [ Calculated,SqlFieldName = DATE_MODIFIED ];

Timestamp for when the class projecting the view definition was last modified.

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

Description for the class that projects the view definition, or if the view is projected from a class query, the class query description.

• property ISTRIGGERDELETABLE as %String(MAXLEN=3) [ Calculated,SqlFieldName = IS_TRIGGER_DELETABLE ];

Reserved for future use. For InterSystems IRIS, IS_TRIGGER_DELETABLE is always NULL.

• property ISTRIGGERINSERTABLEINTO as %String(MAXLEN=3) [ Calculated,SqlFieldName = IS_TRIGGER_INSERTABLE_INTO ];

Reserved for future use. For InterSystems IRIS, IS_TRIGGER_INSERTABLE_INTO is always NULL.

• property ISTRIGGERUPDATABLE as %String(MAXLEN=3) [ Calculated,SqlFieldName = IS_TRIGGER_UPDATABLE ];

Reserved for future use. For InterSystems IRIS, IS_TRIGGER_UPDATABLE is always NULL.

• property ISUPDATABLE as %String(MAXLEN=3) [ SqlFieldName = IS_UPDATABLE ];

Returns YES if the view is updatable, otherwise NO.

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

View's owner

• property Queryname as %String(MAXLEN=254) [ Calculated,SqlFieldName = QUERY_NAME ];

If projected from a class query, name of the query

• 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 view.

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

Name of schema that contains the table.

• property VIEWDEFINITION as %String(MAXLEN=1048576) [ SqlFieldName = VIEW_DEFINITION ];

The view's query expression. If longer than 1048576 characters, only the first 1048573 characters of the query are returned followed by "...".

Class Reference IRIS for UNIX 2024.1.2
Documentation Search