Creates a new table in the database identified by connection reference. The table and column information inputs describe the name of the table and the properties of each column in the table, respectively.


icon

Inputs/Outputs

  • ci32.png primary key (-1) —

    primary key specifies the column that is going to be the primary key for the table. The default is -1, which means the table does not have a primary key.

  • cdlrn.png connection reference —

    connection reference specifies a reference to an ADO Connection object.

  • cstr.png table —

    table is the name of the table in the database to create.

  • c1dcclst.png column information —

    column information specifies an array of clusters that describe each column to be created.

  • cstr.png column name —

    column name is the name of column in database.

  • cenum.png data type —

    data type of column.

  • ci32.png size —

    size of column in database. Only used for string data type.

  • cbool.png allow null? —

    allow null? is a switch to indicate if the column allows NULL values.

  • cerrcodeclst.png error in (no error) —

    error in describes error conditions that occur before this node runs. This input provides standard error in functionality.

  • cbool.png use file? (F) —

    use file? specifies whether to use a user-supplied file to determine native database types. The default is FALSE.

  • idlrn.png connection reference out —

    connection reference out returns a reference to an ADO Connection object.

  • ierrcodeclst.png error out —

    error out contains error information. This output provides standard error out functionality.