Show Table of Contents
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
|
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.