11.5. Column Options
You can use the following options when specifying columns in the creation of a table or view. Any others properties defined will be considered as extension metadata.
|
Property
|
Data Type or Allowed Values
|
Description
|
|---|---|---|
|
UUID
|
string
|
A unique identifier for the column
|
|
NAMEINSOURCE
|
string
|
If this is a column name on the FOREIGN table, this value represents name of the column in source database, if omitted the column name is used when querying for data against the source
|
|
CASE_SENSITIVE
|
'TRUE'|'FALSE'
| |
|
SELECTABLE
|
'TRUE'|'FALSE'
|
TRUE when this column is available for selection from the user query
|
|
UPDATABLE
|
'TRUE'|'FALSE'
|
Defines if the column is updatable. Defaults to true if the view/table is updatable.
|
|
SIGNED
|
'TRUE'|'FALSE'
| |
|
CURRENCY
|
'TRUE'|'FALSE'
| |
|
FIXED_LENGTH
|
'TRUE'|'FALSE'
| |
|
SEARCHABLE
|
'SEARCHABLE'|'UNSEARCHABLE'|'LIKE_ONLY'|'ALL_EXCEPT_LIKE'
|
column searchability, usually dictated by the data type
|
|
MIN_VALUE
| | |
|
MAX_VALUE
| | |
|
CHAR_OCTET_LENGTH
|
integer
| |
|
ANNOTATION
|
string
| |
|
NATIVE_TYPE
|
string
| |
|
RADIX
|
integer
| |
|
NULL_VALUE_COUNT
|
long
|
costing information. Number of NULLS in this column
|
|
DISTINCT_VALUES
|
long
|
costing information. Number of distinct values in this column
|
