INFORMATION.SCHEMA.VIEWS
persistent class INFORMATION.SCHEMA.VIEWS extends %Library.Persistent [ Final ]
SQL Table Name: INFORMATION_SCHEMA.VIEWS
Returns one row for each view in the current namespace for which the current user has privilegesProperty Inventory
- CHECKOPTION
- Classname
- DATECREATED
- DATEMODIFIED
- DESCRIPTION
- ISTRIGGERDELETABLE
- ISTRIGGERINSERTABLEINTO
- ISTRIGGERUPDATABLE
- ISUPDATABLE
- Owner
- Queryname
- TABLECATALOG
- TABLENAME
- TABLESCHEMA
- VIEWDEFINITION
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:
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 InterSystems IRIS, 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 InterSystems IRIS, 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 InterSystems IRIS, 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 InterSystems IRIS.
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 = 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 "...".
Property methods: VIEWDEFINITIONDisplayToLogical(), VIEWDEFINITIONGet(), VIEWDEFINITIONIsValid(), VIEWDEFINITIONLogicalToDisplay(), VIEWDEFINITIONLogicalToOdbc(), VIEWDEFINITIONNormalize(), VIEWDEFINITIONSet()
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %AddToSyncSet()
- %BuildDeferredIndices()
- %BuildIndicesAsync()
- %BuildIndicesAsyncResponse()
- %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()
- %OnDeleteFinally()
- %OnDetermineClass()
- %OnOpenFinally()
- %OnSaveFinally()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
- %ValidateTable()
Storage
Gray indicates storage defined by superclasses.
Storage Model: SQLStorage
Maps: 2
Map number 1 is named Master
thismap.Global: ^rINDEXSQL
Map number 2 is named rxIndex
thismap.Global: ^rINDEXSQL
^rINDEXSQL("VIEW",{SchemaExact},{TableExact})
|
= |
|
^rINDEXSQL("rv",$$UPPER({TABLE_SCHEMA}),$$UPPER({TABLE_NAME}))
|
= |
|