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 Package	Tables	Abstract	Yes
Export Control	PublicAccess	Link Class for	None
Class Kind	NormalClass	Cardinality	n
Space		Concurrency	Sequential
Persistence	No

Attributes

Name	Class	Type	Initial Value
queryExpression	DerivedTable	String
selfRefColumnGeneration	Table	ReferenceType
insertable	Table	boolean
updatable	Table	boolean
name	SQLObject	String
description	SQLObject	String
label	SQLObject	String

Associations

Name	My Role	My Class	Other Role	Other Element
table-column	table	Table	columns	Column
superTable-subTable	supertable	Table	subtables	Table
table-udt	--Not Named--	Table	udt	StructuredUserDefinedType
schema-table	tables	Table	schema	SQLSchema
--Not Named--	subjectTable	Table	triggers	Trigger
referencedatatype-table	scopeTable	Table	--Not Named--	ReferenceDataType

Generalization Relationships

Name	Class	Supplier
--Not Named--	DerivedTable	Table
--Not Named--	Table	SQLObject

Property Settings

Data Modeler

dmItem	False	DMName
IsTable	False	IsView	False
IsDomain	False	IsSPPackage	False
Synonymns		TableSpaceID
SourceId		SourceType
CorrelationName		SelectClause
IsUpdateable	True	CheckOption	None
IsSnapShot	False	IsDistinct	False
PersistToServer		IsPackage	False