Delete statement

Use this property to specify the SQL statement to delete specified rows from an existing database table.

This property is available only if you set the following property values:
  • Write mode to Delete or Delete then insert
  • Generate SQL to No

The following is an example of a DELETE statement where table1 is the name of the table. You must precede the ID of every target table name with the word ORCHESTRATE that is followed by a period. ORCHESTRATE can be capitalized or typed in lowercase letters.

delete from table1 where ID=ORCHESTRATE.ID

Valid values are determined by the specific database.