Delete statement
Use this property to define a DELETE statement to remove rows from the database.
This property is required when the Generate SQL property is set to No and when the Write mode property is set to Delete or Delete then insert.
To
define a DELETE statement:
- Type a statement in the cell next to the Delete statement property.
- Click the browse button to open the Delete Statement window, which contains a large text box where you can type a statement.
- Click the Job Parameter button to use a job parameter.
- Click the Build button to open the SQL Builder window, a graphical interface that helps you build the statement.