Class ViewTable {Analysis} derived from: DerivedTable

Documentation
4.14 Tables

A table is a collection of rows having one or more columns. [...]

A table is either a base table, a derived table, or a transient table. A base table is either a persistent base table, a global temporary table, a created local temporary table, or a declared local temporary table.

A derived table is a table derived directly or indirectly from one or more other tables by the evaluation of a <query expression> whose result has an element type that is a row type. The values of a derived table are derived from the values of the underlying tables when the <query expression> is evaluated.

A viewed table is a named derived table defined by a <view definition> . A viewed table is sometimes called a view.

A view descriptor describes a view. In addition to the components of a derived table descriptor, a view descriptor includes:
- The name of the view.
- An indication of whether the view has the CHECK OPTION ; if so, whether it is to be applied as CASCADED or LOCAL.
- The original <query expression> of the view.


Parent PackageTablesAbstractNo
Export ControlPublicAccessLink Class forNone
Class KindNormalClassCardinalityn
Space ConcurrencySequential
PersistenceNo  


Operations
NameSignatureClass
addEAnnotationEAnnotation addEAnnotation (String source)SQLObject
addEAnnotationDetailvoid addEAnnotationDetail (EAnnotation eAnnotation, String key, String value)SQLObject
getEAnnotationDetailString getEAnnotationDetail (EAnnotation eAnnotation, String key)SQLObject
setAnnotationDetailvoid setAnnotationDetail (EAnnotation eAnnotation, String key, String value)SQLObject
removeEAnnotationDetailvoid removeEAnnotationDetail (EAnnotation eAnnotation, String key)SQLObject
getEAnnotationEAnnotation getEAnnotation (String source)SQLObject


Attributes
NameClassTypeInitial Value
checkTypeViewTableCheckType 
queryExpressionDerivedTableString 
selfRefColumnGenerationTableReferenceType 
insertableTableboolean 
updatableTableboolean 
nameSQLObjectString 
descriptionSQLObjectString 
labelSQLObjectString 


Associations
NameMy RoleMy ClassOther RoleOther Element
--Not Named--supertableTablesubtablesTable
--Not Named--tableTablecolumnsColumn
--Not Named----Not Named--TableudtStructuredUserDefinedType
--Not Named--tablesTableschemaSQLSchema
--Not Named--subjectTableTabletriggersTrigger
--Not Named--scopeTableTable--Not Named--ReferenceDataType


Generalization Relationships
NameClassSupplier
--Not Named--ViewTableDerivedTable
--Not Named--DerivedTableTable
--Not Named--TableSQLObject



Property Settings

Data Modeler
dmItemFalseDMName 
IsTableFalseIsViewFalse
IsDomainFalseIsSPPackageFalse
Synonymns TableSpaceID 
SourceId SourceType 
CorrelationName SelectClause 
IsUpdateableTrueCheckOptionNone
IsSnapShotFalseIsDistinctFalse
PersistToServer IsPackageFalse