Type to start searching...
Change an existing column in a 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
True if the column is case insensitive.
converter : string
Component for custom column data type conversion, implementing the Converter interface.
description : string
Operation description.
literal : boolean
True to disable the bind parameter on this column and use a literal bind instead.
name : dbObjName
Column name.
| Valid values based on“string”. | |
|---|---|
| [A-Za-z][_A-Za-z\d]* | |
nullable : boolean
True if the column is nullable.
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 | |