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.
<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.
- 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.
<Columns> (repetitive exit [required]): The details of the table columns.
- If <Auto Commit> exists and a Yes value is received, the database action is performed
in auto-commit mode, regardless of any active transaction
"SQL Examples/View/Tabbed Pane/Database Details/Get Database Details/Get Database Details" from the
SQL Examples project:
- You get multiple Column Descriptor data structures, each containing the name and type of one column.