Lists the columns present in table. The column information includes the name, the data type, and the defined size of the column.


icon

Inputs/Outputs

  • cdlrn.png connection reference —

    connection reference specifies a reference to an ADO Connection object.

  • cstr.png table —

    table specifies the name of the table to search.

  • cerrcodeclst.png error in (no error) —

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

  • idlrn.png connection reference out —

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

  • i1dcclst.png column information —

    column information returns an array containing information about the columns in the database table.

  • istr.png name —

    name returns the name of the column.

  • cenum.png database data type —

    database data type returns the type of data in the column.

  • ii32.png defined size —

    defined size returns the defined size of the column.

  • i1dstr.png columns —

    columns returns an array of strings containing the names of each column in a database table.

  • ierrcodeclst.png error out —

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