Class DerivedTable {Analysis} derived from: Table

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 derived table descriptor describes a derived table. In addition to the components of every table descriptor, a derived table descriptor includes:
- The <query expression> that defines how the table is to be derived.
- An indication of whether the derived table is updatable or not.


Parent PackageTablesAbstractYes
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
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--DerivedTableTable
--Not Named--TableSQLObject



Property Settings

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