Element Details: Create+DB+Table
 Back


Available in: Logi Info Source code name: CreateDbTable

Will create the specified table on a database server. The table structure can be defined by using the TableSchema attribute or the child element ColumnSchema.

Note: If both TableSchema and ColumnSchema exist the ColumnSchema will take precedence.

Element Group:Load Data Elements



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ConnectionID
UserDefined
Specifies a connection to a data source that is defined in the Settings. For elements connecting to relational databases, default is the first Connection element in _settings.lgx.
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.
IfDbTableExists
Truncate
Recreate
Keep
Action to take if the table already exists. Keep (Default) = Leave the table and existing data untouched. Truncate = Delete any existing records, but leave structure unchanged. Recreate = Delete the table and recreate it with the defined structure.
TableName
UserDefined
(Required) The name of a database table.
TableSchema
UserDefined
Specifies the Etl Extract or Transform element that created the schema for this element. This attribute is not required. When not filled in, the element expects the schema to be defined using the child element ColumnSchema.



PARENT ELEMENTS

Click element to drill down for more information.

Etl Job
If
If ETL Error If File Exists If Folder Exists


CHILD ELEMENTS

Click element to drill down for more information.

Column Schema


 Back to top


 Chart Debug