6.3.21 Table

A materialized NamedColumnSet.

Superclasses

NamedColumnSet

Contained Elements

UniqueConstraint ForeignKey

Attributes

isSystem

Indicates that the Table is a System Table (generally part of or view on the system catalog). type: multiplicity:

Boolean
exactly one

isTemporary

Indicates that the table content is temporary. SQL92 standards provide two types of temporary tables (local Temporary and Global Temporary). However, RDBMS products have implemented variations on this theme. It is recommended that the product manufacturers provide specific temporary information (besides the temporaryScope attribute) in their extensions. type: multiplicity:

Boolean
exactly one

temporaryScope

This attribute is meaningful only when the isTemporary flag is True [C-1]. The scope indicates when the data of this table are available. “SESSION,? “APPLICATION? are examples of possible values. Look at the Scope attribute for Global Temporary tables in the SQL standards for more details. type: multiplicity: constraints:

String
zero or one
May not be specified if isTemporary is set to false.

References

trigger

Associates triggers executed during changes to the table. class: defined by: multiplicity: inverse:

Trigger
TableOwningTrigger::trigger
zero or more; ordered
Trigger::table

Constraints

Attribute temporaryScope is meaningful only when the isTemporary flag is True [C-1]