SQLite: transactions

By default, SQLite is in autocommit mode. In autocommit mode, each DML statement is committed when it finishes.

With begin (or the more verbose but equivalent begin transaction) statement, SQLite is taken out of autocommit mode.

Rolling back a create table

A create table statement can be rolled back:

--
-- Unlike Oracle, the effect of  "create table" statement
-- can be rolled back.
--
create table table_one (a);

begin transaction;
  create table table_two(b);
  create table table_three(b);
rollback;

.tables
--
-- table_one

drop table table_one;

Github repository about-sqlite, path: /sql/transactions/create_table.sql

SQLite: transactions

Rolling back a create table

See also