Delete database records
Crete a database query to delete records from a database table.
On the properties panel of the Data access activity, click
The Data access configuration dialog box is displayed.
Database connection list,
select the process or server variable to specify the database connection string
that holds the details of the relational database.
By default, Tables is selected and all tables within the selected database are available on the Tables list.
- On the Tables list, select the table for which you want to delete the records.
- On the Record list, select Delete.
Configure your query based on some specific conditions. For
example, to delete the records for the cities of London and Berlin, specify the
Click under Search criteria.
Specify the search criteria as Column as City(String), Operator as equals, Criteria as London, and Logic as AND.
Click Add .
Specify another search criteria as Column as City(String), Operator as equals, Criteria as Berlin, and Logic as AND.
- Click OK.