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  


Attributes
NameClassTypeInitial Value
queryExpressionDerivedTableString 
selfRefColumnGenerationTableReferenceType 
insertableTableboolean 
updatableTableboolean 
nameSQLObjectString 
descriptionSQLObjectString 
labelSQLObjectString 


Associations
NameMy RoleMy ClassOther RoleOther Element
table-columntableTablecolumnsColumn
superTable-subTablesupertableTablesubtablesTable
table-udt--Not Named--TableudtStructuredUserDefinedType
schema-tabletablesTableschemaSQLSchema
--Not Named--subjectTableTabletriggersTrigger
referencedatatype-tablescopeTableTable--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