t_RelationalDatabaseUpgrade_CreateColumn

CreateColumn

Add a new column to an existing table.

Properties

allocation : columnAllocation

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

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.

Content

Choice of:
- g_SQLScript_SQL [1..1] - SQL statement. View more details for macro variables.
- g_SQLScript_Switch [1..1]

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