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'
      ```