DB Query to delete database records

  1. On the DB Query Action page of a form, or on the Extended Properties page of a Data Access activity, click Configure.
    The Database Query page appears.
    Note By default, Tables is selected and all tables within the selected database are available on the Table list.
  2. On the Table list, select the table to delete records from. All columns within the selected table appear.
  3. For Record, click Delete.
  4. 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. Column: City(String), Operator: Equal To, Criteria: London, Logic: AND.

    2. Click Add Add.

    3. Column: City(String), Operator: Equal To, Criteria: Berlin.

    4. Click Add Add.

  5. Click OK.
  6. Click Close.