Delete records from a database table

Create a database query to delete records from a database table.

1. On the properties panel of the Data access activity, click Configure.
   The Data access configuration - <Activity name> dialog box is displayed.
2. You can select one of the following for Database connection.

   • Local (Default): Select the process or server variable to specify the database connection string that holds the details of the relational database.

   • External: To use the database connection from external storage, enter the secret name for the connection secret stored in the configured external storage.

   By default, the Tables option is selected and all tables within the selected database are available on the Tables list.

3. On the Tables list, select the table for which you want to delete the records.
4. On the Record list, select Delete.
5. Configure your query based on some specific conditions. For example, to delete the records for the cities of London and Berlin, specify the condition as:

   1. Click  under Search criteria.

   2. Specify the search criteria as Column as City(String), Operator as equals, Criteria as London, and Logic as AND.

   3. Click Add.

   4. Click .

   5. Specify another search criteria as Column as City(String), Operator as equals, Criteria as Berlin, and Logic as AND.

   6. Click Add.

6. Click OK.