Element Details: Column+Schema
 Back


Available in: Logi Info Source code name: ColumnSchema

Used to describe the characteristics of a field for a CreateDbTable element.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
DbColumnName
UserDefined
(Required) Name of the field to create.
DbColumnSize
UserDefined
Size of the field. For data types that require precision, use the comma to seperate the values. E.g. To create a field of type decimal(18,2), size should be set as 18,2. Not all data types require a size value, consult your database documentation.
DbColumnType
UserDefined
(Required) Type of field to create. Basic types include int, decimal, float, varchar, and datetime. The attribute can be set to any data type available in the destination database system. Defaults to varchar.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.



PARENT ELEMENTS

Click element to drill down for more information.

Create DB Table


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top