Differences

This shows you the differences between two versions of the page.

--- transformations:sqlcommand [2025/02/20 18:40] – add Capabilities section craigt
+++ transformations:sqlcommand [2026/09/22 05:51] (current) – Reviewed commands, list table settings. roberto
@@ Line 25: / Line 25: @@
 ^ Setting  ^ Description  ^
 |Connector<sup>*</sup>|Select or create a connector to the database.|
-|Command|Select the process to run on the database.  Options:  //Create table//, //Delete table//, //Delete all rows//, or //Custom command//.|
+|Command|Select the process to run on the database.  Options:  //Custom command//, //Create table//, //Delete table//, //Delete all rows//, //List tables//, or //List table fields//.|
 |Advanced (Timeout)|Set the number of seconds for this process to complete before timing out.  Default is 1800.  If the action has not\\ completed within the set Timeout, the workflow stops and displays an error.|
 <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
@@ Line 65: / Line 65: @@
 \\
 ====List tables settings====
-**Description:**  This command creates a two-column dataset consisting of the Schema name and Table name of all tables in the target database.  No settings are required.
+**Description:**  This command creates a two-column dataset consisting of the Schema name and Table name of all tables in the target database.
+^Settings ^Description ^
+|Only for schema|Optionally check this to only list the tables of a certain schema. Enter the schema name or use the schema picker to select it.|
 \\