Delete records from a database table

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

Before you begin

To use the Data access activity, you must create a process variable to hold the database connection string. For example, create a process variable, with the following settings:

ID = DBConnectionString
Type = String
Value = DSN=TotalAgility

Procedure

On the properties panel of the Data access activity, select Configure.
The Data access configuration - <Activity name> dialog box is displayed.
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.
A list of schema that the database user has permission to access is displayed.
On the Schema list, select a database schema to use for retrieving database objects.

If no schema is selected, the system uses the default schema for the database user (typically dbo for SQL Server).
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 condition as:
1. Select  under Search criteria.
2. Specify the search criteria as Column as City(String), Operator as equals, Criteria as London, and Logic as AND.
3. Select Add.
4. Select .
5. Specify another search criteria as Column as City(String), Operator as equals, Criteria as Berlin, and Logic as AND.
6. Select Add.
Select OK.