By default, the value of auto commit is set to ON. If you want to disable the auto commit, you can do the following steps,
Step 1: From the SAP HANA Studio top menu, go to Window and select Preferences.
Step 2: From SAP HANA, drill down to Runtime and SQL. Under the Connection Parameters for SQL Console, select Off for Auto Commit Mode. Click on Apply and OK. Yes, you are done!
