Deleting Database Records

Automate database record deletion with the Database Book.

To delete a record from the database, use the following procedure:

Syntax

In the following syntax, record is the entry in the database to be deleted. The entry needs to be previously referenced in your automation before you can delete it.

delete {record} from the database

Example

get a database's person whose FirstName is "John"
use the above as the records
use the first record as the person
delete the person from the database

In this example:

• Line 1: Retrieves a database record.

• Line 2: Stores the retrieved records as the records.

• Line 3: Stores only the first record from the records as the person.

• Line 4: Deletes the person.