Skip to main content

INFORMATION.SCHEMA.VIEWS

Class INFORMATION.SCHEMA.VIEWS Extends %Library.Persistent [ ClassType = persistent, Final, Owner = {_PUBLIC}, SqlRowIdPrivate, SqlTableName = VIEWS, StorageStrategy = SQLStorage, System = 4 ]

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

Parameters​

READONLY​

Parameter READONLY = 1;

Properties​

SchemaExact​

Property SchemaExact As %String(MAXLEN = 128) [ Internal, Private, Required, SqlColumnNumber = 20 ];

TableExact​

Property TableExact As %String(MAXLEN = 128) [ Internal, Private, Required, SqlColumnNumber = 21 ];

SystemView​

Property SystemView As %Integer [ Calculated, Internal, Private, Required, SqlColumnNumber = 22, SqlComputeCode = { set {*}=$s($e({TABLE_SCHEMA})="%"||({TABLE_SCHEMA}="INFORMATION_SCHEMA"):1,1:0) }, SqlComputed ];

Is the table a system table (1 or 0)

TABLECATALOG​

Property TABLECATALOG As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 2, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = TABLE_CATALOG ];

Table qualifier - always NULL in InterSystems IRIS.

TABLESCHEMA​

Property TABLESCHEMA As %String(COLLATION = "Upper", MAXLEN = 128) [ Required, SqlColumnNumber = 3, SqlFieldName = TABLE_SCHEMA ];

Name of schema that contains the table.

TABLENAME​

Property TABLENAME As %String(COLLATION = "Upper", MAXLEN = 128) [ Required, SqlColumnNumber = 4, SqlFieldName = TABLE_NAME ];

Name of the view.

VIEWDEFINITION​

Property VIEWDEFINITION As %String(MAXLEN = 1048576) [ SqlColumnNumber = 5, 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 "...".

CHECKOPTION​

Property CHECKOPTION As %String(MAXLEN = 8, VALUELIST = ",CASCADED,LOCAL,NONE") [ Calculated, SqlColumnNumber = 6, SqlComputeCode = { set {*}="" }, SqlComputed, 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.

ISUPDATABLE​

Property ISUPDATABLE As %String(MAXLEN = 3) [ SqlColumnNumber = 7, SqlFieldName = IS_UPDATABLE ];

Returns YES if the view is updatable, otherwise NO.

ISTRIGGERUPDATABLE​

Property ISTRIGGERUPDATABLE As %String(MAXLEN = 3) [ Calculated, SqlColumnNumber = 8, SqlComputeCode = { set {*}="" }, SqlComputed, SqlFieldName = IS_TRIGGER_UPDATABLE ];

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

ISTRIGGERDELETABLE​

Property ISTRIGGERDELETABLE As %String(MAXLEN = 3) [ Calculated, SqlColumnNumber = 9, SqlComputeCode = { set {*}="" }, SqlComputed, SqlFieldName = IS_TRIGGER_DELETABLE ];

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

ISTRIGGERINSERTABLEINTO​

Property ISTRIGGERINSERTABLEINTO As %String(MAXLEN = 3) [ Calculated, SqlColumnNumber = 10, SqlComputeCode = { set {*}="" }, SqlComputed, SqlFieldName = IS_TRIGGER_INSERTABLE_INTO ];

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

DESCRIPTION​

Property DESCRIPTION As %String(MAXLEN = 1024) [ Calculated, SqlColumnNumber = 11, SqlComputeCode = {

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

DATECREATED​

Property DATECREATED As %TimeStamp [ Calculated, SqlColumnNumber = 12, SqlComputeCode = {

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

DATEMODIFIED​

Property DATEMODIFIED As %TimeStamp [ Calculated, SqlColumnNumber = 13, SqlComputeCode = {

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

Classname​

Property Classname As %String(MAXLEN = 254) [ Calculated, SqlColumnNumber = 14, SqlComputeCode = { set {*}=$lg($g(^rINDEXSQL("rv",$zconvert({TABLE_SCHEMA},"u"),$zconvert({TABLE_NAME},"u"))),1) }, SqlComputed, SqlFieldName = CLASSNAME ];

Name of the class that projected the view definition

Owner​

Property Owner As %String(MAXLEN = 254) [ Calculated, SqlColumnNumber = 15, SqlComputeCode = { set {*}=$lg($g(^rINDEXSQL("rv",$zconvert({TABLE_SCHEMA},"u"),$zconvert({TABLE_NAME},"u"))),6) }, SqlComputed, SqlFieldName = OWNER ];

View's owner

Queryname​

Property Queryname As %String(MAXLEN = 254) [ Calculated, SqlColumnNumber = 16, SqlComputeCode = {

If projected from a class query, name of the query