rollback-transaction

Issues with this documentation page? Report here.

Purpose:

Rollbacks a SQL transaction.

Syntax:

rollback-transaction [ @<database> ]

Description:

rollback-transaction will roll back a transaction started with begin-transaction.

Database

Optional <database> is specified in "@" clause and is the name of the database_config_file.

Examples:

begin-transaction @mydb
run-query @mydb="insert into employee (name, dateOfHire) values ('Terry', now())"
run-query @mydb="insert into payroll (name, salary) values ('Terry', 100000)"
rollback-transaction @mydb