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

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

Inventory

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 %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 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 "...".


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