Discover published sets by community

Explore tens of thousands of sets crafted by our community.

Transactional SQL Commands

Flashcards

0/8

Still learning

ROLLBACK WORK

Purpose: To rollback the current transaction, undoing all data modifications. Syntax: ROLLBACK WORK;

ROLLBACK

Purpose: To undo the changes made by the current transaction. Syntax: ROLLBACK [TRANSACTION] [transaction_name];

SET TRANSACTION

Purpose: To establish the characteristics of the current transaction. Syntax: SET TRANSACTION [CHARACTERISTICS] {READ WRITE | READ ONLY};

COMMIT WORK

Purpose: To commit the current transaction and make all data modifications permanent. Syntax: COMMIT WORK;

SAVEPOINT

Purpose: To set a savepoint within a transaction to which one can rollback later. Syntax: SAVEPOINT savepoint_name;

BEGIN TRANSACTION

Purpose: To start a new transaction. Syntax: BEGIN TRANSACTION [transaction_name];

COMMIT

Purpose: To save the changes made by the current transaction. Syntax: COMMIT [TRANSACTION] [transaction_name];

RELEASE SAVEPOINT

Purpose: To remove a savepoint that was set during a transaction. Syntax: RELEASE SAVEPOINT savepoint_name;

Know

Still learning

Click to flip

Know