CreateColumn
Add a new column to an existing table.
Properties
allocation : columnAllocationColumn allocation mode. If a given mode is not supported on a given RDMBS, it is degraded automatically.Valid values based on“string”.fixedvaryinglocatorcaseInsensitive : booleanApplicable 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 : stringComponent for custom column data type conversion, implementing the Converter interface.description : stringColumn description.literal : booleanTrue to disable the bind parameter on this column and use a literal bind instead.name : dbObjNameUniquely identifies the column.Valid values based on“string”.[A-Za-z][_A-Za-z\d]*nullable : booleanTrue 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 : positiveIntColumn 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 : unsignedByteDecimal number scale.table : tableNameTable 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 : columnTypeColumn data type.Valid values based on“string”.stringbinaryintegerlongdecimalfloatdoubletimestampboolean
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
-
g_SQLScript_SQL
SQL statement. View more details for macro variables.
Parent topic: t_Upgrade_RelationalDatabaseUpgrade