Get Columns - Retrieve the details of the columns in a given database table

This action retrieves and returns the details of all columns in a database tables.


<Table> (non-repetitive trigger [required]): Details of the table for which we want to retrieve the column details.

This is a Table Descriptor data structures, containing the name and type of one table, as well as the names of its schema and catalog.

Typically you get it by calling Get Tables.

<Data Source> (non-repetitive trigger [not required]): Name of data source to use (if different from the default data source; see Connecting to an External Database).

<Auto Commit> (non-repetitive Boolean trigger [not required]): Indication whether to interact with the database in auto-commit mode.

If <Auto Commit> exists and a Yes value is received, the database action is performed in auto-commit mode, regardless of any active transaction


<Columns> (repetitive exit [required]): The details of the table columns.

You get multiple Column Descriptor data structures, each containing the name and type of one column.

Usage Example

"SQL Examples/View/Tabbed Pane/Database Details/Get Database Details/Get Database Details" from the SQL Examples project: