SQL Script Executor

You can execute more than one SQL statement, as long as they are separated by semi-colons.

The SQL workflow action is flexible; you can perform procedure calls, create and analyze tables, and more.

Common uses associated with the SQL workflow action include truncating tables, drop index, partition loading, refreshing materialized views, disabling constraints, disabling statistics, and so on..