Home > Class Reference > %SYS namespace > INFORMATION.SCHEMA.VIEWS
Private   Storage    

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

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
1 15

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 Caché, IS_TRIGGER_DELETABLE is always NULL.
property ISTRIGGERINSERTABLEINTO as %String(MAXLEN=3) [ Calculated,SqlFieldName = IS_TRIGGER_INSERTABLE_INTO ];
Reserved for future use. For Caché, IS_TRIGGER_INSERTABLE_INTO is always NULL.
property ISTRIGGERUPDATABLE as %String(MAXLEN=3) [ Calculated,SqlFieldName = IS_TRIGGER_UPDATABLE ];
Reserved for future use. For Caché, 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 Caché.
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=8192) [ SqlFieldName = VIEW_DEFINITION ];
The view's query expression. If longer than 8192 characters, NULL is returned.