t_RelationalDatabaseUpgrade_AlterColumn

AlterColumn

Change an existing column in a table.

Properties

allocation : columnAllocation

Column allocation mode. If a given mode is not supported on a given RDMBS, it is degraded automatically.

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.

Parents

t_Upgrade_RelationalDatabaseUpgrade - The set of Relational Upgrade steps to describe what schema changes took place in this version

Parent topic: t_Upgrade_RelationalDatabaseUpgrade