Ce contenu n'est pas disponible dans la langue sélectionnée.
11.4. Table Options
You can use the following options when creating a table or view. See "create table body" in Section A.7, “Productions”. Any others properties defined will be considered as extension metadata.
|
Property
|
Data Type or Allowed Values
|
Description
|
|---|---|---|
|
UUID
|
string
|
This is the unique identifier for a view.
|
|
MATERIALIZED
|
'TRUE'|'FALSE'
|
This is applicable to views only. It defines if a table is materialized.
|
|
MATERIALIZED_TABLE
|
'table.name'
|
This is applicable to views only. If this view is being materialized to a external database, this defines the name of the table that is being materialized.
|
|
CARDINALITY
|
int
|
Costing information. Number of rows in the table. Used for planning purposes
|
|
UPDATABLE
|
'TRUE'|'FALSE'
|
Defines if the view is allowed to update or not
|
|
ANNOTATION
|
string
|
Description of the view
|
