Type to start searching...
Add a new column to an existing table.
allocation : columnAllocation
Column allocation mode. If a given mode is not supported on a given RDMBS, it is degraded automatically.
| Valid values based on“string”. | |
|---|---|
| fixed | |
| varying | |
| locator | |
caseInsensitive : boolean
Applicable to string columns only. True if the column is case insensitive for searching. (default = true)
It can be automatically set to false if the column participates in primary or foreign keys, is a class code or is longer than 2000 characters.converter : string
Component for custom column data type conversion, implementing the Converter interface.
description : string
Column description.
literal : boolean
True to disable the bind parameter on this column and use a literal bind instead.
name : dbObjName
Uniquely identifies the column.
| Valid values based on“string”. | |
|---|---|
| [A-Za-z][_A-Za-z\d]* | |
nullable : boolean
True if the column is nullable. It can be automatically set to false based on required mapped attributes and column participation in the primary key.
precision : positiveInt
Column precision (decimal, integer) or length (string, binary). For integer columns, it is the number of bytes (1, 2 or 4).
| Valid values based on“int”. | |
|---|---|
| 1 (minInclusive) | |
scale : unsignedByte
Decimal number scale.
table : tableName
Table name, as specified in the data source: [<owner>.]<table>
| Valid values based on“string”. | |
|---|---|
| [A-Za-z][_A-Za-z\d]*(\.[A-Za-z][_A-Za-z\d]*)? | |
type : columnType
Column data type.
| Valid values based on“string”. | |
|---|---|
| string | |
| binary | |
| integer | |
| long | |
| decimal | |
| float | |
| double | |
| timestamp | |
| boolean | |