Skip to main content

INFORMATION.SCHEMA.VIEWS

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

SQL Table Name: INFORMATION_SCHEMA.VIEWS

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

Property Inventory

Parameters

parameter READONLY = 1;
Inherited description: 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 methods: CHECKOPTIONCompute(), CHECKOPTIONDisplayToLogical(), CHECKOPTIONGet(), CHECKOPTIONIsValid(), CHECKOPTIONLogicalToDisplay(), CHECKOPTIONLogicalToOdbc(), CHECKOPTIONNormalize(), CHECKOPTIONSQLCompute()
property Classname as %String (MAXLEN = 254) [ Calculated , SqlFieldName = CLASSNAME ];
Name of the class that projected the view definition
Property methods: ClassnameCompute(), ClassnameDisplayToLogical(), ClassnameGet(), ClassnameIsValid(), ClassnameLogicalToDisplay(), ClassnameLogicalToOdbc(), ClassnameNormalize(), ClassnameSQLCompute()
property DATECREATED as %TimeStamp [ Calculated , SqlFieldName = DATE_CREATED ];
Timestamp for when the class projecting the view definition was created.
Property methods: DATECREATEDCompute(), DATECREATEDDisplayToLogical(), DATECREATEDGet(), DATECREATEDIsValid(), DATECREATEDLogicalToDisplay(), DATECREATEDNormalize(), DATECREATEDOdbcToLogical(), DATECREATEDSQLCompute()
property DATEMODIFIED as %TimeStamp [ Calculated , SqlFieldName = DATE_MODIFIED ];
Timestamp for when the class projecting the view definition was last modified.
Property methods: DATEMODIFIEDCompute(), DATEMODIFIEDDisplayToLogical(), DATEMODIFIEDGet(), DATEMODIFIEDIsValid(), DATEMODIFIEDLogicalToDisplay(), DATEMODIFIEDNormalize(), DATEMODIFIEDOdbcToLogical(), DATEMODIFIEDSQLCompute()
property DESCRIPTION as %String (MAXLEN = 1024) [ Calculated ];
Description for the class that projects the view definition, or if the view is projected from a class query, the class query description.
Property methods: DESCRIPTIONCompute(), DESCRIPTIONDisplayToLogical(), DESCRIPTIONGet(), DESCRIPTIONIsValid(), DESCRIPTIONLogicalToDisplay(), DESCRIPTIONLogicalToOdbc(), DESCRIPTIONNormalize(), DESCRIPTIONSQLCompute()
property ISTRIGGERDELETABLE as %String (MAXLEN = 3) [ Calculated , SqlFieldName = IS_TRIGGER_DELETABLE ];
Reserved for future use. For Caché, IS_TRIGGER_DELETABLE is always NULL.
Property methods: ISTRIGGERDELETABLECompute(), ISTRIGGERDELETABLEDisplayToLogical(), ISTRIGGERDELETABLEGet(), ISTRIGGERDELETABLEIsValid(), ISTRIGGERDELETABLELogicalToDisplay(), ISTRIGGERDELETABLELogicalToOdbc(), ISTRIGGERDELETABLENormalize(), ISTRIGGERDELETABLESQLCompute()
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 methods: ISTRIGGERINSERTABLEINTOCompute(), ISTRIGGERINSERTABLEINTODisplayToLogical(), ISTRIGGERINSERTABLEINTOGet(), ISTRIGGERINSERTABLEINTOIsValid(), ISTRIGGERINSERTABLEINTOLogicalToDisplay(), ISTRIGGERINSERTABLEINTOLogicalToOdbc(), ISTRIGGERINSERTABLEINTONormalize(), ISTRIGGERINSERTABLEINTOSQLCompute()
property ISTRIGGERUPDATABLE as %String (MAXLEN = 3) [ Calculated , SqlFieldName = IS_TRIGGER_UPDATABLE ];
Reserved for future use. For Caché, IS_TRIGGER_UPDATABLE is always NULL.
Property methods: ISTRIGGERUPDATABLECompute(), ISTRIGGERUPDATABLEDisplayToLogical(), ISTRIGGERUPDATABLEGet(), ISTRIGGERUPDATABLEIsValid(), ISTRIGGERUPDATABLELogicalToDisplay(), ISTRIGGERUPDATABLELogicalToOdbc(), ISTRIGGERUPDATABLENormalize(), ISTRIGGERUPDATABLESQLCompute()
property ISUPDATABLE as %String (MAXLEN = 3) [ SqlFieldName = IS_UPDATABLE ];
Returns YES if the view is updatable, otherwise NO.
Property methods: ISUPDATABLEDisplayToLogical(), ISUPDATABLEGet(), ISUPDATABLEIsValid(), ISUPDATABLELogicalToDisplay(), ISUPDATABLELogicalToOdbc(), ISUPDATABLENormalize(), ISUPDATABLESet()
property Owner as %String (MAXLEN = 254) [ Calculated , SqlFieldName = OWNER ];
View's owner
Property methods: OwnerCompute(), OwnerDisplayToLogical(), OwnerGet(), OwnerIsValid(), OwnerLogicalToDisplay(), OwnerLogicalToOdbc(), OwnerNormalize(), OwnerSQLCompute()
property Queryname as %String (MAXLEN = 254) [ Calculated , SqlFieldName = QUERY_NAME ];
If projected from a class query, name of the query
Property methods: QuerynameCompute(), QuerynameDisplayToLogical(), QuerynameGet(), QuerynameIsValid(), QuerynameLogicalToDisplay(), QuerynameLogicalToOdbc(), QuerynameNormalize(), QuerynameSQLCompute()
property TABLECATALOG as %String (MAXLEN = 128) [ Calculated , SqlFieldName = TABLE_CATALOG ];
Table qualifier - always NULL in Caché.
Property methods: TABLECATALOGCompute(), TABLECATALOGDisplayToLogical(), TABLECATALOGGet(), TABLECATALOGIsValid(), TABLECATALOGLogicalToDisplay(), TABLECATALOGLogicalToOdbc(), TABLECATALOGNormalize(), TABLECATALOGSQLCompute()
property TABLENAME as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = TABLE_NAME , Required ];
Name of the view.
Property methods: TABLENAMEDisplayToLogical(), TABLENAMEGet(), TABLENAMEIsValid(), TABLENAMELogicalToDisplay(), TABLENAMELogicalToOdbc(), TABLENAMENormalize(), TABLENAMESet()
property TABLESCHEMA as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = TABLE_SCHEMA , Required ];
Name of schema that contains the table.
Property methods: TABLESCHEMADisplayToLogical(), TABLESCHEMAGet(), TABLESCHEMAIsValid(), TABLESCHEMALogicalToDisplay(), TABLESCHEMALogicalToOdbc(), TABLESCHEMANormalize(), TABLESCHEMASet()
property VIEWDEFINITION as %String (MAXLEN = 8192) [ SqlFieldName = VIEW_DEFINITION ];
The view's query expression. If longer than 8192 characters, NULL is returned.
Property methods: VIEWDEFINITIONDisplayToLogical(), VIEWDEFINITIONGet(), VIEWDEFINITIONIsValid(), VIEWDEFINITIONLogicalToDisplay(), VIEWDEFINITIONLogicalToOdbc(), VIEWDEFINITIONNormalize(), VIEWDEFINITIONSet()

Inherited Members

Inherited Methods

Storage

Gray indicates storage defined by superclasses.

Storage Model: CacheSQLStorage

Maps: 2

  • Map number 1 is named Master

    thismap.Global: ^rINDEXSQL

  • Map number 2 is named rxIndex

    thismap.Global: ^rINDEXSQL

  • ^rINDEXSQL("VIEW",{SchemaExact},{TableExact})
    =
    Node Delimiter Piece Name
    VIEW_DEFINITION
    2 TABLE_SCHEMA
    3 TABLE_NAME
    ^rINDEXSQL("rv",$$UPPER({TABLE_SCHEMA}),$$UPPER({TABLE_NAME}))
    =
    Node Delimiter Piece Name
    TableExact
FeedbackOpens in a new tab