Answer Posted / Kaushal Kumar Singh
Truncate command does not create a new transaction, so it doesn't require an explicit commit. However, if you have an ongoing transaction when executing TRUNCATE, the changes will be part of that transaction and will be committed or rolled back accordingly.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is collation? : Sql dba
define sql insert statement ? : Sql dba
What is your daily office routine?
Is primary key clustered index?
how to use regular expression in pattern match conditions? : Sql dba
Does group by remove duplicates?
how to start mysql server? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
how to escape special characters in sql statements? : Sql dba
what is dbms? : Sql dba
what is bcp? When does it used? : Sql dba
What is the best sql course?
Can we use distinct and group by together?
What is the current version of sql?
how many tables will create when we create table, what are they? : Sql dba
