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
• parameter READONLY = 1;
READONLY = 1 means that objects can be created, opened but not saved or deleted.
Tables are projected to SQL as READONLY.
• 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 "...".
