Delete database records

Crete 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. On the 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.

  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.