RE: How to do a rollback

I do not know for other databases, but for Oracle, DDL (Data Definition
Language) statements cannot be rolled back. DDL statements are all
statements that affect the database structure, like table creation,
index creation, …