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