t_RelationalDatabaseUpgrade_CreateColumn

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


Parents

Parent topic: t_Upgrade_RelationalDatabaseUpgrade