Drop – removes table from SQL data base

Create – creates table in SQL data base

Truncate – deletes all rows (data) in a SQL table

Load – execute standard DWD load procedure and any defined pre and post load procedures

Custom – execute custom procedure associated to table/object

Update – execute update procedure associated to table/object

Execute – execute the procedure or host scripts

Process – drops all indexes on the table, performs the update procedure and rebuilds the indexes