Delete From Table Via JDBC
Use the Delete from Table via JDBC activity to delete column from the table by executing SQL query.
Usage
Complete the following properties to use this activity:
- SQL - Specify the following information or click the Variable Reference icon to choose a variable:
SQL Query to Execute - Enter the SQL query to be executed.
Example of a simple query to delete a column:
``` DELETE from mytable where mycolumn = 'zzz' ```